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.

{a} Nem'raiise 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 tabtes in (a)? {10 marks)