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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!