Based on the table above, answer the following questions…
Based on the table above, answer the following questions 1.1 The table has been flattened i.e. repeating groups have been removed. Which attribute are we talking about? (1) 1.2 What is still needed to bring the table to 1NF? (1) 1.3 Normalise the table to First Normal Form. Display as a relation. (3) 1.4 Explain why Minnie Mouse is regarded as data redundancy and the colour black is regarded as duplicate data. (2) 1.5 Give an example of a deletion anomaly using the table. (2) 1.6 Define Second Normal Form. (2) 1.7 Draw a data dependency table showing all dependencies. (6) 1.8 Define Third Normal Form. (2) 1.9 Explain why your new tables are already in Third Normal Form. (3)