Check sibling questions

Consider the table, MOVIEDETAILS given below: 



(a) Identify the degree and cardinality of the table. 


  • Degree: 5 

(T he degree of a table is the number of columns in the given table )

  • Cardinality: 6

(Cardinality of a table is the number of rows in the given table )


(b) Which field should be made the primary key? Justify your answer. 


MOVIEID should be made the primary key as it uniquely identifies each record of the table.

( A primary key is a column in a table which uniquely identifies each row/record in a database table )



Slide28.JPG Slide29.JPG Slide30.JPG

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

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.