Incorporate the following outline in your submission – include the section numbers – not the questions or other content from the instructions. 1) Review the existing report, functional dependencies provided and the sample data (as well as field domains and common knowledge) and document any assumptions you feel are appropriate (beyond those in the key points) and identify initial entities (person, place, thing). (10%) 2 Define functional dependency, and explain one row of the functional dependencies provided above in plain English (use field names). (15%) (you do not need to explain partial or transitive dependency) 3) Based on multiplicity – explain the relationship between the initial Entities in plain English – (either one-to-many, or many-to-many). (15%)   4) Design: specify all tables and fields at each normal form level a) First Normal Forum (1NF) assessment / action – if needed 10% Copy the 1NF definition from the text (include quotes and page number) Assess the UNF table provided and if necessary, make the changes needed to conform to the 1NF definition. Document the resulting 1NF table(s) using relational schema notation or spreadsheet format (see the above example or page 111 Figure 4.2.6 of the text). Explain how each table(s) meets the 1NF definition (use field names) b) Second Normal Form (2NF) assessment / action – if needed 10% Copy the 2NF definition from the text (include quotes and page number) Assess the 1NF table(s) in the previous section and if necessary, make the changes needed to conform to the 2NF definition. Document the resulting 2NF table(s) using relational schema notation or spreadsheet format. Explain how each table meets the 2NF definition (use field names) c) Third Normal Form (3NF) assessment / action if needed 10% Copy the 3NF definition from the text (include quotes and page number) Assess the 2NF table(s) in the previous section and if necessary, make the changes needed to conform to the 3NF definition. Document the resulting 3NF table(s) using relational schema notation or spreadsheet format. Explain how each table meets the 3NF definition (use field names) 5) Use the 3NF tables in your design, to create an new MS Access database, load the sample data provided, Name your database Last Name_TermProject (i.e. Smith_TermProject). (5%). 6) Create a Query, that provides the results for the following request: List each PilotID, FirstName, LastName, the Airline each pilot works for, sorted by pilot. (5%) 7) Create a Form: New Pilot Input (5%) 8) Create a Report: Pilot List – list all pilots, their first and last names, and Salary (5%) Upload the database to the assignment area as one of the deliverables 9) Submission content organization, clarity, spelling and grammar (10%)   Contact the instructor with any questions.