An online flight booking company wishes to set up a database to record details of flights, airline companies, pilots, customers, and bookings made on flights.
For each flight, the information recorded includes a unique flight number, source, destination, departure date, and time. A flight is one of two type’s domestic or international, for domestic flights a maximum baggage weight is recorded, international flights have no such limit but do record a visa requirement.
Flights are operated by an airline company; an airline company will operate many flights. The information stored on the Airline Company includes the company name, phone number, and email.
Customers make bookings for flights, a flight will be booked by many bookings, and a customer will make many bookings. A booking is made by one customer and books one flight. Each booking has a unique reference and number of seats booked. The information stored on each customer includes a
unique customer code, name, address, and phone number. A flight is the responsibility of one pilot, a pilot will be responsible for many flights during Their career.
For each pilot, their unique employee number is recorded along with a name, address, and phone number. A flight will be assigned a second pilot (copilot) to assist the pilot of the flight and a given pilot will assist on many flights. A flight will always have one pilot and one co-pilot.
Draw an Entity Relationship diagram for this database, and decompose any many to many relationships. Include any additional constraints, assumptions, and limitations that support your understanding of the above scenario.
List the entity types, their attributes, and their primary key.
Implement these tables as a database using MS Office.
Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services
The post An online flight booking company wishes to set up a database to record details of flights, airline companies, pilots, customers: Financial Systems Analysis Assignment, UOG, Ireland appeared first on QQI Assignments.
