In this assignment, you will work on one of the first stages of the development of a relational database. This is the creation of the ER Diagram that will represent the conceptual model of the Relational Database for the Small Commuter Airline Reservation System. Analysts have already met with the stakeholders of the Small Commuter Airline to better understand the requirements for the software system and relational database. Written below are some of the requirements relative to the development of the database component for the system.

The company wants to maintain Customer Information. They need the customer's name, phone number, and email address when a Seat Reservation is placed by a Customer on any of the aircraft. They also want to store Aircraft information, Flight Information, and Pilot Information

The company wants to maintain records of the aircraft information. The company wants a digital list of the reservation history and travel history and flight history. The important information to maintain about an aircraft is that aircraft have a unique id number, make, model, and seating capacity

The company wants to track the flights that an aircraft has been assigned to. A flight has a departure point, a destination, a departure time, and an arrival time. An aircraft is assigned to a flight. A pilot is assigned to a flight, and the Customer reserves a seat on an aircraft for a flight. These are very small aircraft. There are only 5 to ten seats available on each aircraft.

The company wants to maintain records of basic Pilot information. They would like to track and maintain the data on the pilot's license number the pilot, name of the pilot, cell phone number of the pilot, and the miles the pilot has flown.

The company wants to maintain a digital list of the aircraft that a pilot has been assigned to. This will include the dates and times that the pilot was assigned to the aircraft.

The company wants to track when a customer is assigned to a seat on an aircraft. An aircraft can have many seat assignments for a specific flight.