While the data model design process was still underway, an enterprising accountant had already started putting...

Transcribed Image Text:

While the data model design process was still underway, an enterprising accountant had already started putting together data in a spreadsheet. The CEO applauded his enthusiasm, but she is worried about the integrity of the data, even though the accountant says his data is in the first normal form already. Here is a sample of the spreadsheet data, in first normal form (underlined columns names indicate the composite primary key): Company Company Department Department Product Product ID Name ID Name VR1000 1 ACME VR 1 1 ACME VR ACME VR ACME Movies 2 3 ACME Movies 4 1 1 2 2 Name Production Production HR Finance Production Draw a dependency diagram to show the partial and transitive dependencies in this data. ID 1 0 0 0 2 Product Product Type ID Type Name 1 Headset No Product No Product No Product MC9 2 Date 3306/01/23 3306/01/24 3306/01/23 3306/01/23 3306/01/23 Camera Value 521 -250 105 999 50 While the data model design process was still underway, an enterprising accountant had already started putting together data in a spreadsheet. The CEO applauded his enthusiasm, but she is worried about the integrity of the data, even though the accountant says his data is in the first normal form already. Here is a sample of the spreadsheet data, in first normal form (underlined columns names indicate the composite primary key): Company Company Department Department Product Product ID Name ID Name VR1000 1 ACME VR 1 1 ACME VR ACME VR ACME Movies 2 3 ACME Movies 4 1 1 2 2 Name Production Production HR Finance Production Draw a dependency diagram to show the partial and transitive dependencies in this data. ID 1 0 0 0 2 Product Product Type ID Type Name 1 Headset No Product No Product No Product MC9 2 Date 3306/01/23 3306/01/24 3306/01/23 3306/01/23 3306/01/23 Camera Value 521 -250 105 999 50