Question: I need help normalizing to 3NF and verification that I have gotten the 1NF and 2NF correct on this if possible. This is my 1NF
I need help normalizing to 3NF and verification that I have gotten the 1NF and 2NF correct on this if possible.
This is my 1NF

This is my 2NF



The original chart is above

I can't seem to get to find a way to get to the 3NF I don't know if it's because I've messed up somewhere in the process in the 1NF or 2NF.
Purchaselte.- PurchasePri PurchaseDa1- Vendor Phone 2063257866 2063257866 2063257866 2063257866 2063256755 2063256755 2063258977 2063258977 2063256755 2063256755 4357464322 4357465433 4357465433 2063259088 2063259088 ID Click to Add 2 Antique Desk 3 Antique Candle 4 Antique Candle 5 Dining Table Li 6 Candles Antique Desk $1,800.00 $1,750.00 $210.00 $200.00 $600.00 11/7/2015 European Specialties 11/7/2015 European Specialties 11/7/2015 European Specialties 11/7/2015 European Specialties 11/14/2015 Linens and Things $10.00 11/14/2015 Linens and Things 150.00 11/14/2015 Lamps and Lighting $300.00 11/14/2015 Lamps and Lighting $450.00 11/21/2015 Linens and Things $27.00 11/21/2015 Linens and Things 150.00 11/21/2015 Harison, Denise 7 Desk Lamp 8 Floor Lamp 9 Dining Table Li 10 Candles 11 Book Shelf 12 Antique Desk 13 Antique Desk C 14 Antique Chair 15 Antique Chair $1,000.00 11/28/2015 Lee, Andrew 300.00 11/28/2015 Lee, Andrew $750.00 11/28/2015 New York Brokerage $1,050.00 11/28/2015 New York Brokerage (New) $0.00 0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
