Observe the following table and answer the part (i) and (ii) accordingly. Table: Member
Observe the following table and answer the part (i) and (ii) accordingly.
Table: Member
| Mno | Name | Qty | Purchase Date |
| 101 | Pen | 102 | 12-12-2011 |
| 102 | Pencil | 201 | 21-0202012 |
| 102 | Eraser | 90 | 09-08-2010 |
| 109 | Sharpener | 90 | 31-08-2012 |
| 113 | Clips | 900 | 08-08-2011 |
1. 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?
4 views
1 Answers
1. No
2. Degree = 4
Cardinality = 5
[Hint: Because Pencil and Eraser are having the same Mno = 2. Primary key needs to be unique]
4 views
Answered