Question

Draw an ER diagram for the following Reservation database (please show all the cardinalities and participation ratios): 1. We need to store the SSN, name, address, gender, date of birth and phone number of each Passenger. For the ticket reservation, we will need to know the passenger's first, middle and last names. The SSN will be unique for each Passenger. 2. We need to store the flight ID, type and the number of seats of each flight. The flight ID will be unique for each Flight. 3. We need to store information about Travel Agencies available for flight ticket reservations. Each Travel agency will have an Agency ID, name, location and phone number. A Travel agency may have more than one location and Agency ID will be unique for each Book. 4. We need to store Airline ID, company, Type and phone number of Airline. Each Airline is uniquely identified by Airline ID. 5. We need to store information about Airports where flights arrive at and depart from. So, we record code, name, location and phone number of each Airport. Each Airport is uniquely identified by code. 6. Passenger may have a visitor, but a visitor must belong to at least one passenger. A visitor cannot exist if the passenger does not exist. For each visitor, we will store the name, gender, birth date and relationship. Additional information: A Passenger may make Flight ticket reservations through a Travel Agency. And a Travel Agency may make many flight ticket reservations for many passengers. A Flight must belong to one and only one Airlines, whereas an Airline may operate many Flights. A Flight may arrive at an Airport and the arrival time is recorded in the database. A Flight may depart from an Airport and the departure time is recorded in the database. An Airport may handle many flight arrivals and departures each day.

Draw an ER diagram for the following Reservation database (please show all the cardinalities and participation ratios):
1. We need to store the SSN, name, address, gender, date of birth and phone number of each Passenger. For the ticket reservation, we will need to know the
passenger's first, middle and last names. The SSN will be unique for each Passenger.
2. We need to store the flight ID, type and the number of seats of each flight. The flight ID will be unique for each Flight.
3. We need to store information about Travel Agencies available for flight ticket reservations. Each Travel agency will have an Agency ID, name, location and phone
number. A Travel agency may have more than one location and Agency ID will be unique for each Book.
4. We need to store Airline ID, company, Type and phone number of Airline. Each Airline is uniquely identified by Airline ID.
5. We need to store information about Airports where flights arrive at and depart from. So, we record code, name, location and phone number of each Airport. Each
Airport is uniquely identified by code.
6. Passenger may have a visitor, but a visitor must belong to at least one passenger. A visitor cannot exist if the passenger does not exist. For each visitor, we will
store the name, gender, birth date and relationship.
Additional information:
A Passenger may make Flight ticket reservations through a Travel Agency. And a Travel Agency may make many flight ticket reservations for many passengers.
A Flight must belong to one and only one Airlines, whereas an Airline may operate many Flights.
A Flight may arrive at an Airport and the arrival time is recorded in the database.
A Flight may depart from an Airport and the departure time is recorded in the database.
An Airport may handle many flight arrivals and departures each day.

Added by Daniel W.

Question

Please give Ace some feedback