Air-india want to create database to stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same. Draw an ER diagram based on the information given. Consider the following requirements list: • The airline has one or more airplanes. • An airplane has a model number, a unique registration number, and the capacity to take at most 100 passengers. • An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. • Each flight is carried out by a single airplane. • A passenger has given names, a surname, and a unique email address. • A passenger can book at most 5 seats on a flight. [7] (b) Convert the diagram 1(a) in relational model.
Air-india want to create
seat bookings. Again, it’s a hugely simplified version of what a real airline would use,
but the principles are the same. Draw an ER diagram based on the information given.
Consider the following requirements list:
• The airline has one or more airplanes.
• An airplane has a model number, a unique registration number, and the capacity
to take at most 100 passengers.
• An airplane flight has a unique flight number, a departure airport, a destination
airport, a departure date and time, and an arrival date and time.
• Each flight is carried out by a single airplane.
• A passenger has given names, a surname, and a unique email address.
• A passenger can book at most 5 seats on a flight.
[7]
(b) Convert the diagram 1(a) in relational model.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
