Question: Develop the database for an airline in MYSQL and present the screenshot (e.g., SQL commands for developing tables, Output screen of each table, etc.) Consider

 Develop the database for an airline in MYSQL and present the
screenshot (e.g., SQL commands for developing tables, Output screen of each table,

Develop the database for an airline in MYSQL and present the screenshot (e.g., SQL commands for developing tables, Output screen of each table, etc.) Consider the design which you answered for question no 2. a. Creating minimum 4 Tables (6 marks) b. Entering data into those tables (4 marks) c. Keep track of customers and their reservations (10 marks) customer customer id name address age phone email no of seats has reservation schedule has_schedule schedule id source_airport destination airport date flight flight id name type capacity has_route route route id airport next destination has_allocated seat_assignments seat id class

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!