Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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. racted from: Database Processing: Fundamentals, Design, and Implementation, David M. Kroenke and David Auer, 14th ed, Global Edition, Pearse prial Compiled by: Anupam Makhija King's Own Institute • 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.

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. racted from: Database Processing: Fundamentals, Design, and Implementation, David M. Kroenke and David Auer, 14th ed, Global Edition, Pearse prial Compiled by: Anupam Makhija King's Own Institute • 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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
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
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS