Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions