2.3 Normalize a wholesale company's database Given below is the design of a Sales table for a wholesale company. Indicate the primary key for the table. Given the current design of this table, list two violations of the basic requirements of a relational data model. Indicate possible anomalies in the table and then normalize the table to third normal form.

Transcribed Image Text:

SO# Invoice Date Item Description Quantity Unit Customer# # Ordered Price 101 7/5/2006 2033 Washer 5 $359.99 22 Customer Name Brown Co. 2051 Dryer 8 $372.00 102 7/5/2006 1099 TV 4 $258.00 26 Homebase 103 7/6/2006 2028 VCR 10 $179.99 24 Easy Shop 2034 CD player 10 $185.00 2045 DVD player 5 $200.00 104 7/8/2000 1099 TV 15 $258.00 22 22 Brown Co.