Store ID S-100 S-100 S-101 In the Store_Sales table, the Item_Code and Store_ID are key attributes....

Transcribed Image Text:

Store ID S-100 S-100 S-101 In the Store_Sales table, the Item_Code and Store_ID are key attributes. Street Main St Main St 3rd St City ZipCode Item_Code LA 90010 1-200 90010 1-201 90011 1-200 LA Item_Description Quantity 30 22 54 Something Good Something Better Something Good Unit Price 25 35 25 1) (5 pts) Explain if this is in 1st Normal Form. 2) (10 pts) Explain if this is in 2nd Normal Form. Use specific attribute names in your explanation. 3) (15 pts) If it is not in 2nd Normal Form, create tables in 2nd Normal Form. Store ID S-100 S-100 S-101 In the Store_Sales table, the Item_Code and Store_ID are key attributes. Street Main St Main St 3rd St City ZipCode Item_Code LA 90010 1-200 90010 1-201 90011 1-200 LA Item_Description Quantity 30 22 54 Something Good Something Better Something Good Unit Price 25 35 25 1) (5 pts) Explain if this is in 1st Normal Form. 2) (10 pts) Explain if this is in 2nd Normal Form. Use specific attribute names in your explanation. 3) (15 pts) If it is not in 2nd Normal Form, create tables in 2nd Normal Form.

Answer rating: 100% (QA)

5 pts Explain if this is in 1st Normal Form To determine if the given table is in the 1st Normal For... View the full answer