Normalization question

QUESTION 3 The dependency diagram shown below indicates several dependencies. A1 A2 A3 A4 A5 A6 A7 (b) Identify and discuss each of the indicated dependencies in the diagram, explain the types of dependency that are present. Is this relation in INF explain your answer? (9 marks) Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table. Explain the criteria required for a relation to be in 2NF. (8 marks) Create a database whose tables are at least in 3NF, showing the dependency diagram for each table. Explain the criteria required for a relation to be in 3NF. (8 marks) Total (25 marks)