Question 1

ProductSpec

Size	Color	Price
S	black	55.9
M	red	70
L	black	70

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

True

False

Question 2

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

True

False

Question 3

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

True

False

Question 4

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

True

False

Question 5

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

True

False

Question 6

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

True

False

Question 73 pts

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

True

False

Question 8

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

True

False

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.

True

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.

True

False

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.

True

False