Normalize this table in Third Normal Form (3NF) CustID CusName CustAddress CustPhone ProductID Product Category Product Desc OrderID Amount Sales personID Sales personName 1001 Steve White 20 North Alafaya, Orlando FL 32828 (407)001 0001 (321)001 0001 A2000 Appliances Stove 1202101 $ 800 00 500 Mike 1002 Jamal Dabouz 15 35th Steet, Miami FL 38055 (407)001 0002 H3000 Houshold Table 1202102 $ 200 00 500 Mike 1003 Lee Min 200 MLK RD, Tampa FL 37055 (305)002 002 A5000 Appliances Fridge Samsung 1202103 $ 950 00 400 Andrea 1004 Yolanda Lopez 89 Buchanon Ave, Jacksonville FL 36512 (718)003 0003 H4000 Houshold Chair 1202104 $ 125 00 300 Sanika 1001 Steve White 20 North Alafaya, Orlando FL 32828 (407)001 0001 (321)001 0001 A4000 Appliances Washer Machine 1202101 $ 700 00 500 Mike 1004 Yolanda Lopez 89 Buchanon Ave, Jacksonville FL 36512 (718)003 003 A2000 Appliances Stove 1202105 $ 800 00 300 Sanika CustID CusName CustAddress ProductID Product Category Product Desc OrderID Amount Sales personID Sales personName 1001 Steve White 20 North Alafaya, Orlando, FL 32828 A2000 Appliances Stove 1202101 $ 800 00 500 Mike 500 Mike 1002 Jamal Dabouz 15 35th Steet, Miami, FL 38055 1003 Lee Min 200 MLK RD, Tampa FL 37055 1004 Yolanda Lopez 89 Buchanon Ave, Jacksonville FL 36512 CustPhone (407)001 0001 (321)001 0001 (407)001 0002 (305)002 002 (718)003 0003 (407)001 0001 (321)001 0001 (718)003 003 H3000 A5000 H4000 Houshold Appliances Houshold Table Fridge Samsung Chair 1202102 1202103 1202104 $ 200 00 $ 950 00 $ 125 00 400 300 Andrea Sanika 1001 Steve White 20 North Alafaya, Orlando FL 32828 A4000 Appliances Washer Machine 1202101 $ 700 00 500 Mike 1004 Yolanda Lopez 89 Buchanon Ave, Jacksonville FL 36512 A 2000 Appliances Stove 1202105 $ 800 00 300 Sanika

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 22, 2024

Normalize this table in Third Normal Form (3NF). CustID CusName CustAddress CustPhone ProductID Product_Category Product_Desc OrderID Amount Sales_personID Sales_personName 1001 Steve White 20 North Alafaya,

Normalize this table in Third Normal Form (3NF).

CustID	CusName	CustAddress	CustPhone	ProductID	Product_Category	Product_Desc	OrderID	Amount	Sales_personID	Sales_personName
1001	Steve White	20 North Alafaya, Orlando. FL 32828	(407)001-0001 (321)001-0001	A2000	Appliances	Stove	1202101	$ 800.00	500	Mike
1002	Jamal Dabouz	15 35th Steet, Miami. FL 38055	(407)001-0002	H3000	Houshold	Table	1202102	$ 200.00	500	Mike
1003	Lee Min	200 MLK RD, Tampa. FL 37055	(305)002-002	A5000	Appliances	Fridge Samsung	1202103	$ 950.00	400	Andrea
1004	Yolanda Lopez	89 Buchanon Ave, Jacksonville. FL 36512	(718)003-0003	H4000	Houshold	Chair	1202104	$ 125.00	300	Sanika
1001	Steve White	20 North Alafaya, Orlando. FL 32828	(407)001-0001 (321)001-0001	A4000	Appliances	Washer Machine	1202101	$ 700.00	500	Mike
1004	Yolanda Lopez	89 Buchanon Ave, Jacksonville. FL 36512	(718)003-003	A2000	Appliances	Stove	1202105	$ 800.00	300	Sanika

image text in transcribed

CustID CusName CustAddress ProductID Product_Category Product Desc OrderID Amount Sales personID Sales personName 1001 Steve White 20 North Alafaya, Orlando, FL 32828 A2000 Appliances Stove 1202101 $ 800.00 500 Mike 500 Mike 1002 Jamal Dabouz 15 35th Steet, Miami, FL 38055 1003 Lee Min 200 MLK RD, Tampa. FL 37055 1004 Yolanda Lopez 89 Buchanon Ave, Jacksonville. FL 36512 CustPhone (407)001-0001 (321)001-0001 (407)001-0002 (305)002-002 (718)003-0003 (407)001-0001 (321)001-0001 (718)003-003 H3000 A5000 H4000 Houshold Appliances Houshold Table Fridge Samsung Chair 1202102 1202103 1202104 $ 200.00 $ 950.00 $ 125.00 400 300 Andrea Sanika 1001 Steve White 20 North Alafaya, Orlando. FL 32828 A4000 Appliances Washer Machine 1202101 $ 700.00 500 Mike 1004 Yolanda Lopez 89 Buchanon Ave, Jacksonville. FL 36512 A 2000 Appliances Stove 1202105 $ 800.00 300 Sanika