Answer these True/False questions based on ProductSpec table for questions 9 - 1

ID: 3726804 • Letter: A

Question

Answer these True/False questions based on ProductSpec table for questions 9 - 11

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.

Use the Above table for question 14

14. T/F The above Students is a 1NF but not 2NF table.

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

9)----true,because when condition to choose,it can be anything red or black so depend on each other.

10)----true, A compound key consists of more than one attribute to uniquely identify an entity occurrence.

11) false,primary key uniquely identify all attributes but it can not.

14)false, SID is a candidate key which determine all attributes and SID is not proper subset of candidate key so no partial dependency.

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