Database Assignment
TigerOne is newly formed Flight Operations Company that is targeting domestic travelers. The company needs a database to track flights, customers, fares, airplane performance, and personnel assignment. Since the company is promoting itself as providing "fast way out of town flights," individual seats are not assigned. More specific notes about different parts of the database are listed below:
• Information about a flight includes its unique flight number, its origin, its destination, and estimated departure and arrival times. To reduce costs, the company only has nonstop flights with a single origin and destination.
• Flights are scheduled for one or more dates with an airplane and a crew assigned to each scheduled flight, and the remaining capacity (seats remaining) noted. In a crew assignment, the employee number and job title (e.g., pilot, flight attendant) are noted.
• Airplanes have a unique serial number, a model, a capacity, and a next scheduled maintenance date.
• Crew members have a unique employee number, a name, a phone, and a job title.
• Customers have a unique customer number, a phone number, and a name.
• Records are maintained for reservations of scheduled flights including a unique reservation number, the flight information, flight date, a customer number, and the fare.
A sample of the data items mentioned above is provided in the attached three reports; Report1.pdf, Report2.pdf, and Report3.pdf. Using the information provided to you, perform the following tasks:
1. Draw the Entity Relationship Diagram (ERD) for database. Use he Craw's Foot notation to draw the ERD.
2. Identify ALL the Functional Dependencies (FDs) and construct normalized tables in the 4NF.
3. If needed, update your ERD to reflect any changes resulting from the normalization process and make.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Report-1-2-and-3.rar