(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)

1H 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. m Airlinejame Mrthejhune Pilut_u:Hn m PlsLMdress Mouton ------ Evmv um um ca I as snares-:5 Eli-1511M 1: Emma" h' s s on: Pita l l c: ' roam .l a" sense BIL'hen ' sfns {a} Nonnalise the above spreadsheets to tables in third normal form {EMF}. Specify the primary key and foreign key {if any} for each table. {5 marks] {or} Develop an Entity-Relationship Diagram [ERD] from the tables in [a]? (10 marks}