Table: PRODUCT ProductID** Sizes Available Price 1 Small, Medium 15.99 2 Small,
ID: 3741128 • Letter: T
Question
Table: PRODUCT
ProductID**
Sizes Available
Price
1
Small, Medium
15.99
2
Small, Medium, Large
13.99
3
Small
22.99
4
Small
17.50
5
Large, Extra Large
19.99
**Primary key
What, if any, normalization is present in this table?
None
First normal form
Second normal form
Third normal form
- Display the modified table or tables that would correct the normalization error, if one is present. Be sure to indicate primary (**) and foreign (*) keys.
ProductID**
Sizes Available
Price
1
Small, Medium
15.99
2
Small, Medium, Large
13.99
3
Small
22.99
4
Small
17.50
5
Large, Extra Large
19.99
Explanation / Answer
1)
Table is in 1NF , an attribute (column) of a table cannot hold multiple values.
Primary key Product Id
2) second NF
Primary key : Product ID
Product Id is Primary Key
Product Id Size Avaialab price 1 Small 15.99 1 Medium 15.99 2 small 13,99 2 Medium 13.99 2 Avaerage 13.99 3 Small 22.99 4 Small 17.50 5 Large 19.99 5 Extra Large 19.99Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.