Business Scenario A database is being constructed to keep track of the airports and airplanes. An airport is identified by airport code and has its own name, city and state. Each airport is landed by a number of airplane type. An airplane type is identified by type name and lands in multiple airports. It also has maximum seats and company. Each airplane type belongs to many airplanes. Airplane is identified by airplane ID and includes total number of seats. An airplane is assigned to multiple leg instance, Leg instance has number of available seats. Multiple flight leg must depart or arrive at an airport. A flight leg includes number of legs. A flight has multiple legs A flight is identified by its number and includes airline name and date. Note: A leg instance is a particular occurrence of a leg on a particular date. A flight leg is a non-stop portion of a flight. Question 1 (25 Marks) a) Analyze the given business scenario and explain how do you carry out design and development of the relational database based on Database Development Life Cycle phases (15 Marks) b) Identify strong and weak (if any) entities from the scenario. Clearly mention the attributes types of each entity. (10 Marks) (10 Marks) Question 2 (25 Marks) For the given business scenario, you are required to provide the following. a) Create the E-R dingram with appropriate relationships and cardinalities. (You can add any relevant attributes to the entities if that's justifiable) (15 Marks) b) Convert the E-R diagram from Question 2a) into relations (logical design) with appropriate primary key and foreign key constraints. Make sure each relations are well structured and in 34 Normal Form. (10 Marks) ...Continue ASR D FOR DFU