(i) Write the names of most appropriate columns, which can be considered as candidate keys.

Question

Observe the following table and answer the parts(i) and(ii) accordingly

Table:Product

| Pno | Name | Qty | PurchaseDate |
| 101 | Pen | 102 | 12 - 12 - 2011 |
| 102 | Pencil | 201 | 21 - 02 - 2013 |
| 103 | Eraser | 90 | 09 -08 - 2010 |
| 109 | Sharpener | 90 | 31 - 08 - 2012 |
| 113 | Clips | 900 | 12 - 12 - 2011 |

(i) Write the names of most appropriate columns, which can be considered as candidate keys.

(ii) What is the degree and cardinality of the above table?

Answer 1

(i) Candidate Key: Pno, Name

(ii) Degree:4

Cardinality:5