Answer these True/False questions based on ProductSpec table 1. Price functional

ID: 3725755 • Letter: A

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 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

Note: 4 sub parts at a time please -- Policy of Chegg

Question 1

Price functionally depends on Size because Size determines Price.

True

Explanation: All the values in Size are different. So, it can determine the price.

Question 2

It is true that Price can determine Size.

False

Explanation: Since 2 prices are same for sizes M and L. Price can't determine.

Question 3

Color --> Size

False

Explanation: Since 2 colors are same for sizes S and L. Color can't determine Size.

Question 4

Size does not determine Color.

False

Explanation: All sizes are unique. So, size can determine color.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.