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 70Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started