Prepare the 3NF base tables needed to produce the sales report view shown in the diagram forProblem.

Transcribed Image Text:

NoRMAIZATION OF DATA Sales Report Customer Number: 19321 Customer Name : Jon Smith Address : 520 Main St.,City Invoice Num Date 12390 Invoice Total Part Num Quantity Unit Price Extd Price 10 25 10 11/11/09 S100 500 250 10 12912 11/21/09 Customer Total: $1,150 Customer Number: 19322 Customer Name : Mary Smith Address : 2289 Elm St., City Invoice Num Date 12421 Invoice Total Part Num Qaity Unit Price Ext'd Price 10 11/13/09 $200 100 700 $1,000 2 100 12901 11/20V09 10 10 20 Customer Total: $1,500 Next Customer Next Customer