Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Company ID Department Department Product ID Company Product Product Product Date Value Name VR1000 No Product No Product No Product MC9 Name Name ID Type ID Type Name ACME VR ACME VR ACME VR ACME Movies ACME Movies Headset 3306/01/23 3306/01/24 3306/01/23 3306/01/23 Camera 3306/01/23 Production 1 521 Production HR Finance Production -250 105 999 2 4 50 Q.5.1 Explain how each of the following data anomalies could arise in this sample data: Q.5.1.1 Update anomaly.

Company ID Department Department Product ID Company Product Product Product Date Value Name VR1000 No Product No Product No Product MC9 Name Name ID Type ID Type Name ACME VR ACME VR ACME VR ACME Movies ACME Movies Headset 3306/01/23 3306/01/24 3306/01/23 3306/01/23 Camera 3306/01/23 Production 1 521 Production HR Finance Production -250 105 999 2 4 50 Q.5.1 Explain how each of the following data anomalies could arise in this sample data: Q.5.1.1 Update anomaly.

MIS
MIS
9th Edition
ISBN:9781337681919
Author:BIDGOLI
Publisher:BIDGOLI
Chapter3: Database Systems, Data Warehouses, And Data Marts
Section: Chapter Questions
Problem 6P
See similar textbooks
icon
Related questions
Question
100%
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 Name Product Product Product Date Value ID Name ID ID Name Type ID Type Name Headset 3306/01/23 3306/01/24 3306/01/23 3306/01/23 Camera 3306/01/23 ACME VR Production 1 VR1000 1 521 ACME VR 1 Production No Product -250 ACME VR 2 HR No Product 105 ACME Movies ACME Movies 2 Finance No Product 999 2 Production 2 MC9 2 50 Q.5.1 Explain how each of the following data anomalies could arise in this sample data: Q.5.1.1 Update anomaly.
Transcribed Image Text: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 Name Product Product Product Date Value ID Name ID ID Name Type ID Type Name Headset 3306/01/23 3306/01/24 3306/01/23 3306/01/23 Camera 3306/01/23 ACME VR Production 1 VR1000 1 521 ACME VR 1 Production No Product -250 ACME VR 2 HR No Product 105 ACME Movies ACME Movies 2 Finance No Product 999 2 Production 2 MC9 2 50 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. 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. 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 Product Product ID Name Type ID Type Name 1 VR1000 1 Headset 2 MC9 2 Camera 3 AR26 1 Headset
Transcribed Image Text:Q.5.1.2 Insertion anomaly. Q.5.1.3 Deletion anomaly. 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. 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 Product Product ID Name Type ID Type Name 1 VR1000 1 Headset 2 MC9 2 Camera 3 AR26 1 Headset
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Risks related to security
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS