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.
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Applications
Section5.7: Information Systems @ Work: Brandwatch: Applying Business Intelligence To Social Media Data To Make Advertising Decisions
Problem 1CTQ
Related questions
Question
100%
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 now
This is a popular solution!
Step by step
Solved 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.Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning