(Marks:20) Question 2 - Normalisation Answer this question in your answer script/answer booklet provided. The scientific

[answerhappygod]

Marks 20 Question 2 Normalisation Answer This Question In Your Answer Script Answer Booklet Provided The Scientific 1 (61.82 KiB) Viewed 42 times

(Marks:20) Question 2 - Normalisation Answer this question in your answer script/answer booklet provided. The scientific research organisation has already collected a lot of data in a spreadsheet (an extract from the spreadsheet is shown below). The data has been normalised to first normal form already - underlined column names indicate composite primary key columns Date User Species English Name User User ID Species ID Main Colour ID Name Sumame 2 5 1 Main Colour Name Blue Blue White Orange White 1 Bob Sam Smith Ngwe kazi Smith Smith 2 2 African grass blue African grass blue Brown-veined white African monarch African migrant 2022/01/28 2022/01/29 2022/02/03 2022/03/01 2022/03/06 1 1 3 2 1 Bob Bob Sarah 2 19 3 Bhebhe Note: The data reflects when a specific user first sighted a specific species. Normalise the above data to the second normal form (2NF). Show all steps as well as the final answer in the form of dependency diagrams.