Question 5 (Marks: 25) While the datamodel design process was still underway, an enterprising accountant started putting

[answerhappygod]

Question 5 Marks 25 While The Datamodel Design Process Was Still Underway An Enterprising Accountant Started Putting 1 (39.93 KiB) Viewed 27 times

Question 5 (Marks: 25) While the datamodel design process was still underway, an enterprising accountant started putting together data in a spreadsheet already. Tshepo applauded his enthusiasm, but he is worried about the integrity of the data, despite the fact that the accountant says his data is in 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 10 ID Name Name 10 Name 1 1 Production 1 1 Production HE 1 1 2 2 ACME VR ACME VR ACME VR ACME Movies ACME Movies 21, 22:23 4 0 Finance 0 Production 2 The Independent Institute of Education (Pty) 2022 Q.5.1 Explain how each of the following data anomalies could arise in this sample data: Q.5.1.1 Update anomaly. Q.5.1.2 Insertion anomaly. Q.5.1.3 Deletion anomaly. No Product No Product No Product MC9 Product Product Type ID Type Name Product ID 1 2 3 Date Value 1 Headuet 1306/03/20 525 3306/01/24 -250 3306/21/23 105 3306/03/23 995 50 Q.5.2 Draw a dependency diagram to show the partial and transitive dependencies in this data. Q.5.3 What are the two major differences between the accountant's data and the business rules that were provided by Tshepo? For each difference, explain which option is better, and why. Product Name VR1000 MC9 AR26 Q.5.4 A software developer suggested to create (among others) a Product table for the second normal form of the data (a sample of the data is shown below). Normalise this table to third normal form, showing all steps. Show table(s) with the data. Product Product Type ID Type Name 1 2 1 Headset Camera Headset (2) P7f8 2022 (2) (2) (6) (6) (7)