Lab 6 1. Given the table T(A,B,C,D,E) with functional dependencies ABC and C-DE. explain why this table is or is not in 3NF. If the table is not in 3NF, decompose it into tables that are in 3NE 2. Given the table T(A,BC,D,E) with functional dependencies AB and C-DE, explain why this table is or is not in 3NF. If the table is not in 3NF, decompose it into tables that are in 3NE 3. Give functional dependencies for the table T(A.B.C,D,E) that would result in a 3NF table The following table, called "tennis" records tennis victories at the four grand slam events for the past 3 years: Year Grand Slam Winner Homeland Host_Nation 2015 Australian Open Djokovic Serbia Australia 2015 French Open Wawrinka Switzerland France 2015 Wimbledon Djokovic Serbia England 2015 US Open Djokovic Serbia United States 2016 Australian Open Djokovic Serbia Australia French Open Djokovic Serbia France 2016 Wimbledon Murray Scotland England 2016 US Open Wawrinka Switzerland United States 2017 Australian Open Federer Switzerland Australia 2017 French Open Nadal Spain France 2017 Wimbledon Federer Switzerland England 2017 US Open Nadal Spain United States 4. What are the functional dependencies of this table? ANSWER: Grand Slam - Host_nation Winner homeland Year, Grand Slam -- winner 5. Why isn't this table in 3NF? 6. Give an example of an update anomaly for this table (Hint: What would happen if somebody wanted to move?) 2016 7. Break this table into multiple tables that are in 3NE. For each table give the name of the table, the attributes within the table and the functional dependencies for each table