Database Questions INVOICE DATE CUSTOMER NAME Phone PRODUCT PRICE(S) QUANTITY TO
ID: 3876761 • Letter: D
Question
Database Questions
INVOICE DATE CUSTOMER NAME Phone PRODUCT PRICE(S) QUANTITY TOTAL(S) 3 1001 2014-03-08 00:00:00 Myron Orlando 1001 2014-03-08 00:00:00 Myron Orlando 1002 2014-03-08 00:00:00 Leona Dunne 1003 2014-03-08 00:00:00 Kathy Smith 1003 2014-03-08 00:00:00 Kathy Smith 1003 2014-03-08 00:00:00 Kathy Smith 1004 2014-03-09 00:00:00 Leona Dunne 1004 2014-03-09 00:00:00 Leona Dunne (615)222-1672 Rat-tail file (615)222-1672 Houselite chain saw, 16-in. bar 190 (713)894-1238 Sledge hammer, 16-lb. head 19 (615)894-2285 Claw hammer (615)894-2285 Steel tape, 12-ft. length (615)894-2285 Rat-tail file (713)894-1238 Claw hammer (713)894-1238 Rat-tail file 3 190 2 13 13 3 13 3 13 2 a) What problem would you encounter if you want to list the records by customer's last name and area code? How would you change the file structure to solve the problem? b) Find the data redundancies in the file structure. How can those redundancies lead to data anomalies? What type of anomaly are they?Explanation / Answer
a.
The Customer's LastName and Area Code are not separate attributes listed in the file. Customer Lastname is part of Customer Name and Area Code is part of Phone attribute. The required attributes need to be extracted . There is need to add two additional attributes. The attributes should be Invoice, Date, Customer FirstName , Customer LastName , Area Code, Phone,Product,Price,Quantity and Total.
b.
Data Redundancies
The attributes Invoice,Date,Customer Name, Phone are repeated in the file which leads to redundancy . these redundancies can lead to anomalies.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.