Database Question INVOICE DATE CUSTOMER NAME Phone PRODUCT PRICE(S) QUANTITY TOT
ID: 3876814 • Letter: D
Question
Database Question
INVOICE DATE CUSTOMER NAME Phone PRODUCT PRICE(S) QUANTITY TOTAL(S) 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 3 (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 38 13 2 13 13 3 13 6 2 a) Identify the various data sources (subjects) in the file. b) Based on the answer to Problem (a), what files would you create to solve the data redundancies and data anomalies in the file structure.Explanation / Answer
a) The various data sources in the given file would be Invoice,pone,customer and product.
b)As per above data sources, to avoid data redundancies I would recommend to create new files like one file required for one customer which should be tied to previous purchases,and one file for each product which predicts total sales.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.