QuesAns Print Page – Computer Sir Ki Class

Login


Lost your password?

Don't have an account ?
Register (It's FREE) ×
  


Shop
siteicon
Q&A CBSE12S-2019-C05A #6618

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:

(i) Candidate Key: Pno, Name
(ii) Degree:4
Cardinality:5