home work

Question-2 [20 marks] Airline Reservation and Ticket Booking System (ARTBS) manages the basic operations such as search for airline flights, choose a flight based on some flight's details, reservation of flight and cancellation of reservation. In this regard, you are asked to do some research about ARTBS, select one of the aspects that managed by ARTBS and then design two database tables about this aspect (14 marks) and another database table that represents a relation between the previous two tables [6 marks). For each table you need to: 1. Define the objective(s) of the table. 2- Design at least five fields for the table; data type and size. 3- Determine the primary key of the table. M275-TMA Page -2- Spring 2020 2021