Normalization of Data Prepare the 3NF base tables needed to produce the sales report view on page 489.

Transcribed Image Text:

Customer Number: 19321 Customer Name Address : Jon Smith : 520 Main St., City Problem 13: Normalization of Data Sales Report Invoice Num Date Invoice Total Part Num Quantity 12390 11/11/07 $850 2 5 1 3 25 12912 11/21/07 $300 4 10 Unit Price $20 50 Ext'd Price $100 500 TTTT 10 10 250 $30 $300 Customer Total: $1,150 Customer Number: 19322 Customer Name : Mary Smith Address : 2289 Elm St., City Invoice Num 12421 Date 11/13/07 Invoice Total $1,000 Part Num 6 Quantity 10 1 2 5 7 12901 11/20/07 $500 4 10 2 10 50 100 700 TITT 100 $300 200 Unit Price Ext'd Price $20 $200 $30 20 Customer Total: $1,500 Next Customer Next Customer