Check sibling questions

Consider the table, MOVIEDETAILS given below: 

Table: MOVIE DETAILS

1.jpg

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

Answer

  • 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. 

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 )

983 students joined Teachoo Black. What are you waiting for?

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.