Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database assignment number 3, Assignments of Database Management Systems (DBMS)

Aga Khan University (AKU)Database Management Systems (DBMS)

database assignment type word file .

Typology: Assignments

2019/2020

Uploaded on 06/01/2022

saqlain-ali-shah
saqlain-ali-shah 🇵🇰

1 document

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
COMSATS University Islamabad, Attock Campus
Department of Computer Sciences
Assignment 03
Course: - Database Systems
Question 1.
Mention the ERD diagram of your project that you have selected. Mention all entities , attributes,
relationship and cardinality of your project.
Question 2.
You are required to create a conceptual data model of the data requirements for a company that
specializes in IT training. The Company has 30 instructors and can handle up to 100 trainees per
training session. The Company offers five advanced technology courses, each of which is taught
by a teaching team of two or more instructors. Each instructor is assigned to a maximum of two
teaching teams or may be assigned to do research. Each trainee undertakes one advanced
technology course per training session.
a. Identify the main entity types for the company.
b. Identify the main relationship types and specify the multiplicity for each relationship.
State any assumptions you make about the data.
c. Using your answers for (a) and (b), draw a single ER diagram to represent the data
requirements for the company.
Question 3.
UPS (Universal Parcel Services) prides itself on having up-to-date information on the processing
and current location of each shipped item. To do this, UPS relies on a company-wide information
system. Shipped items are the heart of the UPS product tracking information system. Shipped
Page 1 of 3
pf3

Partial preview of the text

Download Database assignment number 3 and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

COMSATS University Islamabad, Attock Campus

Department of Computer Sciences

Assignment 03 Course: - Database Systems Question 1. Mention the ERD diagram of your project that you have selected. Mention all entities , attributes, relationship and cardinality of your project. Question 2. You are required to create a conceptual data model of the data requirements for a company that specializes in IT training. The Company has 30 instructors and can handle up to 100 trainees per training session. The Company offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors. Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session. a. Identify the main entity types for the company. b. Identify the main relationship types and specify the multiplicity for each relationship. State any assumptions you make about the data. c. Using your answers for (a) and (b), draw a single ER diagram to represent the data requirements for the company. Question 3. UPS (Universal Parcel Services) prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped

items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a delivery route. Please create an Entity Relationship diagram that captures this information about the UPS system. Be certain to indicate identifiers and cardinality constraints. Question 4. Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer.  Each musician that records at Notown has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.  Each instrument used in songs recorded at Notown has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, B-flat, E-flat).  Each album recorded on the Notown label has a unique identification number, a title, a copyright data, a format (e.g., CD or MC), and an album identifier.  Each song recorded at Notown has a title and an author.  Each musician may play several instruments, and a given instrument may be played by several musicians.  Each album has a number of songs on it, but no song may appear on more than one album.  Each songs is performed by one or more musicians, and a musician may perform a number of songs.  Each album has exactly one musician who acts as its producer. A musician may produce several albums. Question 5 The organizers of the EXAM 2018 international multi-conference need to keep track of a large collection of workshops associated with the event. Initial requirements analysis brings out the following information about what needs to be recorded.

  • Each workshop has a name, and happens on a particular date — or dates, as some workshops last more than one day. •
  • There are several participants, each of which may sign up to one or more workshops.
  • For each participant, it is important to record their name, email address, and the workshops which they wish to attend.