Question 7 (Choice 1) - CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science - Solutions to CBSE Sample Paper - Computer Science Class 12

Consider the table, MOVIEDETAILS given below: 

Table: MOVIE DETAILS

(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 )