Consider the AIRLINE relational database which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER, and consists of one or more FLIGHT_LEGS with LEG_NUMBERS 1, 2, 3, and so on. Each leg has scheduled arrival and departure times and airports and has many LEG_INSTANCES-one for each DATE on which the flight travels. FARES are kept for each flight and PASSENGERS can book flights to any AIRPORT in the world. For each leg instance, SEAT_RESERVATIONS are kept, as are the AIRPLANE used on the leg and the actual arrival and departure times and airports. An AIRPLANE is identified by an AIRPLANE_ID and is of a particular AIRPLANE_TYPE. CAN_LAND relates AIRPLANE_TYPES to the AIRPORTS in which they can land. An AIRPORT is identified by an AIRPORT_CODE. Consider an update for the AIRLINE database to enter a reservation on a particular flight or flight leg on a given date.

Given the operations and the conceptual EER model above;

1. Design the Enhanced Entity Relationship Diagram for the narrative above.
2. Write appropriate SQL DDL statements to define at least five tables for the AIRLINE database.
3. Write the appropriate SQL statement to add the field Date_of_Birth to the customer table.
4. Write the appropriate SQL statement to report on all tables so far created.