Task 3: Normalize the below given voyage attendance report to First Normal Form, Second Normal Form and Thind Normal Form. Make assumptions for the identification of the primary key wherever necessary. (45 Marks) MEC_AMO_TEM_034_1 Fundamentals of Relational Database Management Systems (COMP 20002) Spring - 2020 - CW Page 2 at 9 Assignment1 - All- QP Note: The flight number and mileoge foom on origin te e destinetion nerer waries. Rules & Regulations: - All resources should be cited using Cu Harvard style. - The final assignment must have a Title page, Table of Contents, References/ bibliography using CU Harvard Style and page numbers. - Title Page must have Assignment Name, Module name, Session, your name, 10 , and the name of the faculty. - Softcopy in word format is to be submitted through Tumitin link on Moodle - Viva will be conducted after the assignment submission as per the dates informed earlier. Guidelines: - Assignment must be computer typed. - Font - Times New Roman - Font-5tyle-Regular - Font - Size - 12 - Heading should be with Font Size 14, Bold, Capital and Underline. CS.VS. 1146 - Task 3: Normalize the below given voyage attendance report to First Normal Form, Second Normal Form and Thind Normal Form. Make assumptions for the identification of the primary key wherever necessary. (45 Marks) MEC_AMO_TEM_034_1 Fundamentals of Relational Database Management Systems (COMP 20002) Spring - 2020 - CW Page 2 at 9 Assignment1 - All- QP Note: The flight number and mileoge foom on origin te e destinetion nerer waries. Rules & Regulations: - All resources should be cited using Cu Harvard style. - The final assignment must have a Title page, Table of Contents, References/ bibliography using CU Harvard Style and page numbers. - Title Page must have Assignment Name, Module name, Session, your name, 10 , and the name of the faculty. - Softcopy in word format is to be submitted through Tumitin link on Moodle - Viva will be conducted after the assignment submission as per the dates informed earlier. Guidelines: - Assignment must be computer typed. - Font - Times New Roman - Font-5tyle-Regular - Font - Size - 12 - Heading should be with Font Size 14, Bold, Capital and Underline. CS.VS. 1146