identify one redundant data in the table and explain why it is redundant (D) identify one insertion anomaly and explain it(E) identify 3 full functional dependencies and state your assumptions 

Transcribed Image Text:

Name: (28 pts.) The table below stored customer invoices. Each customer has a unique customer# and may have multiple invoices. Each invoice has a unique invoice number and may have one or multiple invoice lines. Each invoice line is for only one product. For example, the customer #9870 (Winston) in the table below has two invoices, #105 and #260. The invoice #105 contained two invoice lines, each of which is for a different product. Those attributes are self- explanatory. Note that the sample data in the table below are only for illustration limited by the space. Customer# 9870 9870 7840 9870 Name Winston Winston Harris Winston Mobile Invoice# 123-221-3344 105 123-221-3344 105 721-531-5133 210 123-221-3344 260 *** Invoice Date InvoiceLine# 2/10/2013 1 2/10/2013 2 2/12/2013 1 3/15/2013 1 ProductNum 3412-CH 5623-WR 3412-CH 2311-SQ Product Desc Claw Hammer B&D jigsaw Claw Hammer PVC pipe ... Unit 20 5 15 40 ... UnitPrice 25.00 120.00 25.00 6.500 *** ease answer the following questions. (Note that each question consists of two parts. Make sure you give complete wers. You may state your assumptions to clarify ambiguities or missing information but do not change and tradict to the given table.) Name: (28 pts.) The table below stored customer invoices. Each customer has a unique customer# and may have multiple invoices. Each invoice has a unique invoice number and may have one or multiple invoice lines. Each invoice line is for only one product. For example, the customer #9870 (Winston) in the table below has two invoices, #105 and #260. The invoice #105 contained two invoice lines, each of which is for a different product. Those attributes are self- explanatory. Note that the sample data in the table below are only for illustration limited by the space. Customer# 9870 9870 7840 9870 Name Winston Winston Harris Winston Mobile Invoice# 123-221-3344 105 123-221-3344 105 721-531-5133 210 123-221-3344 260 *** Invoice Date InvoiceLine# 2/10/2013 1 2/10/2013 2 2/12/2013 1 3/15/2013 1 ProductNum 3412-CH 5623-WR 3412-CH 2311-SQ Product Desc Claw Hammer B&D jigsaw Claw Hammer PVC pipe ... Unit 20 5 15 40 ... UnitPrice 25.00 120.00 25.00 6.500 *** ease answer the following questions. (Note that each question consists of two parts. Make sure you give complete wers. You may state your assumptions to clarify ambiguities or missing information but do not change and tradict to the given table.)

Answer rating: 100% (QA)

D One example of redundant data in the table is the Name attribute This attribute is redundant becau... View the full answer