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

Question

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 7

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.

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

If you post more tham 1 question, as per chegg guidelines I ahve to solve only 1 question.

Ques 1. True

The columns Color and Price are not unique. So, we can't uniquely define Size with them individualy. But if we use then both in combination, each row is unique. Hence, we can uniquely define size with ( Color, Price ) pair.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

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