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