Question: Answer these True/False questions based on ProductSpec table 1. Price functionally depends on Size because Size determines Price. 2. it is true thatPrice can determine

Answer these True/False questions based on ProductSpec table
1. Price functionally depends on Size because Size determines Price.
2. it is true thatPrice can determine Size.
3. Color --> Size.
4. Size does not determine Color.
5. Size depends on (Color, Price).
6. neither Color nor Price could be a determinant but Size could.
7. If Size is the primary key, the ProductSpec table is nota 3NF.
8. If (Color, Price) is the primary key of the ProductSpec table is 2NF
9. if size L is changed to size M, i.e., both last two rows have same size M, then Size and Price depend on each other.
10. if size L is changed to size M, i.e., both last two rows have same size M, then the primary key must be a compound key
11. if size L is changed to size M, i.e., both last two rows have same size M, then (Size, Price) can be the primary key
ProductSpec Size Color Price S black 55.9 M red 70 L black 70
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
