Provide any two points on Anomalies? a. b. Consider the un-normalized table below. Find the anomalies...

 

Transcribed Image Text:

Provide any two points on Anomalies? a. b. Consider the un-normalized table below. Find the anomalies in the table. OrderID OrderDate CustId CustName Item ID 100 22/12/2017 6011 Ali PR001 ItemName Printer Quantity 1 UnitPrice 45 100 24/12/2017 6011 Ali KEYP6 Keyboard 2 117 121 27/12/2017 2532 Shafi KEYP6 Keyboard 1 117 141 30/12/2017 4853 Azhar SC005 Scanner 1 35 Insert Anomaly Delete Anomaly Update Anomaly Provide any two points on Anomalies? a. b. Consider the un-normalized table below. Find the anomalies in the table. OrderID OrderDate CustId CustName Item ID 100 22/12/2017 6011 Ali PR001 ItemName Printer Quantity 1 UnitPrice 45 100 24/12/2017 6011 Ali KEYP6 Keyboard 2 117 121 27/12/2017 2532 Shafi KEYP6 Keyboard 1 117 141 30/12/2017 4853 Azhar SC005 Scanner 1 35 Insert Anomaly Delete Anomaly Update Anomaly

Answer rating: 100% (QA)

Answer Points on anamolies Firstly take a simple look at the definition of the anamoly Anomalies are problems that can occur in poorly planned unnorma... View the full answer