Question: - Using the INVOICE table given below, draw its dependency diagram and identify all dependencies (including transitive and partial dependencies). You can assume that the


- 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 2 NF. - 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
