Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
100%
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.
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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.
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education