.

Compulsory Task Answer the following questions: - Using the INVOICE table given below, draw its dependency diagram and identify all dependencies (including transitive and partial dependencies). You can assume that the table does not contain any repeating groups and that an invoice number references more than one product. Hint: This table uses a composite primary key - Draw new dependency diagrams to show the data in 2NF. - Draw new dependency diagrams to show the data in 3NF. - Use this table to illustrate one of each kind of anomaly described in the task. In a text file called anomalies.txt, how you would change the table and which anomaly that change would create