Observe the following table and answer the parts
(i) and (ii):
(i) In the above table, can we have Qty as primary key.
Primary key refers to a set of one or more attributes which can uniquely identify tuples in a relation.
In the above table, there is a duplication of values in the column Qty. So the attribute Qty cannot uniquely identify the tuples in a relation. Hence, we cannot set Qty as the primary key.
(ii) What is the cardinality and degree of the above table?
Cardinality refers to the number of tuples/rows in a table.
Degree refers to the number of attributes/columns in a table.
So for the above table,
Cardinality = 5
Degree = 4
Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.
Hi, it looks like you're using AdBlock :(
Displaying ads are our only source of revenue. To help Teachoo create more content, and view the ad-free version of Teachooo... please purchase Teachoo Black subscription.