Question 2 - Normalisation Answer this question in your answer script/answer booklet provided. Mar The scientific resear

[answerhappygod]

Question 2 Normalisation Answer This Question In Your Answer Script Answer Booklet Provided Mar The Scientific Resear 1 (49.29 KiB) Viewed 34 times

Question 2 - Normalisation Answer this question in your answer script/answer booklet provided. Mar The scientific research organisation has already collected a lot of data in a spreadsheet (an extra from the spreadsheet is shown below). The data has been normalised to first normal form already - underlined column names indicate composite primary key columns User IR User Name User Surname Species Species English Name ID I 2 Date 1 Bob Sam Bob Bob Sarah Smith Ngwe kazi Smith Smith Bhebhe 1 3 5 5 1 2. Main Colour ID 1 1 2 African grass blue African grass blue Brown-veined white African monarch African migrant Main Colour Name Blue Blue White Orange White 19 Note: The data reflects when a specific user first sighted a specific species. dos 3 2022/01/28 2022/01/29 2022/02/03 2022/03/01 2022/03/06 2 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. vd banget dosle