Question 1 Based on the data of ProductSpec table shown above, Price functionall

Question

Question 1

Based on the data of ProductSpec table shown above, Price functionally depends on Size because Size determines Price.  

Question 2

Based on the same ProductSpec table shown in Question 1, it is true that Price can determine Size.  

Question 3

Based on the same ProductSpec table shown in Question 1, Color --> Size.

False

Question 4

Based on the same ProductSpec table shown in Question 1, Size does not determine Color.

Question 5

Based on the same ProductSpec table shown in Question 1, Size depends on (Color, Price).  

Question 6

Based on the same ProductSpec table shown in Question 1, neither Color nor Price could be a determinant but Size could.

Question 73 pts

If Size is the primary key, the ProductSpec table shown in Question 1 is not a 3NF.

Question 8

If (Color, Price) is the primary key of the ProductSpec table shown in Question 1, this table is 2NF.

Question 9

In ProductSpec table shown in Question 1, 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.

False

Question 10

In ProductSpec table shown in Question 1, 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.

Question 11

In ProductSpec table shown in Question 1, 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.

Explanation / Answer

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.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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