Types 01 (10 Marks) Question 2 (25 Marks) For the given business scenario, you are required to provide the following. a) Create the E-R diagram 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 3rd Normal Form. (10 Marks) ...Continue ASR 274 ate ) BI i Search 319_BDM1024_QP_Sem2110 - Word at References Mailings Review View Help A A A A E L AD A a. AaBbc a. AaBb AaBbCeDd 1-1. AaB AaBbcc AaBbce 1 Letterlis... Letterlists... 1 Normal T Number... TROPE R... Body Tes 6 Paragraph 15 Styles 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. 1 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. Types 01 (10 Marks) Question 2 (25 Marks) For the given business scenario, you are required to provide the following. a) Create the E-R diagram 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 3rd Normal Form. (10 Marks) ...Continue ASR 274 ate ) BI i Search 319_BDM1024_QP_Sem2110 - Word at References Mailings Review View Help A A A A E L AD A a. AaBbc a. AaBb AaBbCeDd 1-1. AaB AaBbcc AaBbce 1 Letterlis... Letterlists... 1 Normal T Number... TROPE R... Body Tes 6 Paragraph 15 Styles 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. 1 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