Observe the following table and answer the part (i) and (ii) accordin

1.	Observe the following table and answer the part (i) and (ii) accordingly.Table: MemberMnoNameQtyPurchase Date101Pen10212-12-2011102Pencil20121-0202012102Eraser9009-08-2010109Sharpener9031-08-2012113Clips90008-08-20111. In the above table, can we take Mno as Primary key ? (Answer as [Yes/No] only.) Justify your answer with a valid reason.2. What is the degree and the cardinality of the above table?
Answer» 1. No 2. Degree = 4 Cardinality = 5 [Hint: Because Pencil and Eraser are having the same Mno = 2. Primary key needs to be unique]

Observe the following table and answer the part (i) and (ii) accordingly.Table: MemberMnoNameQtyPurchase Date101Pen10212-12-2011102Pencil20121-0202012102Eraser9009-08-2010109Sharpener9031-08-2012113Clips90008-08-20111. In the above table, can we take Mno as Primary key ? (Answer as [Yes/No] only.) Justify your answer with a valid reason.2. What is the degree and the cardinality of the above table?

Answer»

1. No

2. Degree = 4

Cardinality = 5

[Hint: Because Pencil and Eraser are having the same Mno = 2. Primary key needs to be unique]