Question
Create an TWO ERD's from the following requirement . Use Chen notation with cardinality and participation notation and make a separate diagram with UML notation
Create an TWO ERD's from the following requirement. Use Chen notation with cardinality and participation notation and make a separate diagram with UML notation. If you make an assumption that is not in the requirements, please note this on the ER.
Airline Reservation System: This database is for an airline reservation system. You will need to track the flights available. Each flight has a flight number, a destination city and a departure city, a date, a departure time, an arrival time, the total number of passengers booked on the flight and a total flight time (total flight time will not be stored to improve performance). Each flight is assigned a specific plane. A plane consists of an ID, a type (747, 777, 777X), and a maximum occupancy. Customers make reservations on flights. For each customer, we want to track a last name, address, and frequent flyer program type (gold, silver, copper). We also want to track up to 5 phone numbers per customer.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started