
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
thumb_up100%

Transcribed Image Text:Qn 4: Draw an ERD using the following scenario:
Prepare an Entity Relationship Diagram (ERD) showing all primary and non-primary key
attributes for the scenario provided below.
Fly Every Where (FEW) maintains a database about airlines, passengers and their reservation to
perform their business activities. The information about the data stored by FEW database is as
follows:
• FEW has collaborations with many airlines. Each airline has a unique identification
number, contact person name and contact number.
• The airline has one or more aircrafts. Information stored about aircraft includes a
model number, a unique registration number, and the capacity to take one or more
passengers.
• An aircraft can fly in many flights but each flight is carried by a single aircraft.
• Each flight is referenced by unique identifier flight number, a departure airport, a
destination airport, departure date and time and arrival date and time.
• Passengers are referenced by their unique email ID, first name, last name, mobile and
address.
Questions extracted from: Database Processing: Fundamentals, Design, and Implementation, David M. Kroenke and David Auer, 14th ed, Global Edition, Pearson
ICT200 Tutorial
Compiled by: Anupam Makhija
K >KOI
King's Own Institute
Aliandef aindgethy Lad )
ingingom
A passenger can book one or many seats on a flight. A passenger can book any
number of flights and a flight cab be booked by any number of passengers.
• When a booking done, also number of seats booked and amount is recorded.
Questions:
a) Identify attributes and associate them with entity or relationship types. Represent each
attribute in your ER diagram.
b) Identify the main relationship types between the entity types identified in part (a) and
represent each relationship on your ER diagram.
c) Show the primary and foreign key attributes for each entity.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Can you give an example of an entity in the MiniMarket Warehouse Database, please input in the table like in the picture THANK YOUUarrow_forward1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.arrow_forwardUsing er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd. You need to design a database to keep track of clubs at a high school. Attributes: A student may only join one club Some students do not join at all Club needs to have one student Need to capture students: Name Address Year of grad All Phone numbers Club name Club advisor Meeting datesarrow_forward
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education