Observe the following table and answer the parts(i) and(ii) accordingly Table:Product Pno Name Qty Purchase Date 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 (2) (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?
Answers
Answer:
Oswaal Editorial Board This latest offering Oswaal Books is developed by “Oswaal Panel of Experts”. Oswaal Books strongly believes in Making Learning Simple. To ensure student friendly yet highly exam-oriented content, we take due care in developing our Panel of Experts. Accomplished teachers with 100+ years of combined experience, Subject Matter Experts with unmatchable subject knowledge, dynamic educationists, professionals with keen interest in education and topper students from the length and breadth of the country, together form the coveted Oswaal Panel of Experts. It is with their expertise, guidance and keen eye for details that the content in each offering from Oswaal Books meets highest quality standards. No wonder, Oswaal Books holds an enviable place in every student’s heart! · 2019
(a) Observe the following table and answer the parts(i) and(ii) accordingly [2] Table : Product Pno Name Qty PurchaseDate 101 Pen 102 12-12-2011 102 Pencil 201 21-02 ...