The Airport Authority of Utopia maintains a spreadsheet to store information about airlines, pilots and planes. There is only one airport but several airlines use it. The airport employs you as consultant to develop a simple database system. You are required to normalise the following spreadsheet and create an Entity-Relationship Diagram (ERD) to match the resulting tables of the data normalisation process. The following are some sample data on the spreadsheet. Airline_ID Airline_Name Airline_Phone Pilot_LicNo Pilot_Name Pilot_Address Pilot_DOB CX Capital (03) 99876543 A1567832 H.Simpson 12 Smith Rd. Sydney 4/12/1953 UG United (02) 94212321 A1786542 A.Khan 7 Cedar Pl. Ryde 22/10/1957 Miracle (02) 98098761 B3219210 B.Chen 9 Kings Rd. St Kilda 6/05/1961 14 Bradman Av, CX Capital (03) 99876543 B4351220 S.Waugh 5/5/1972 Central Coast Miracle (02) 98098761 B3219210 B.Chen 9 Kings Rd. St Kilda 6/05/1961 Pilot_Age Plane_ID Year Made Model Capacity Max Range 52 CX747021 1990 747 410 15,000km 48 UGDC810 1987 DC8 150 11,000km 44 MA737T1 1995 A310 220 9,000km 33 CX747021 1990 747 410 15,000km 44 MA747T5 1996 747 410 15,000km (a) Normalise the above spreadsheets to tables in third normal form (3NF). Specify the primary key and foreign key (if any) for each table. (5 marks) (b) Develop an Entity-Relationship Diagram (ERD) from the tables in (a)? (10 marks)