Consider the table, MOVIEDETAILS given below:
Table: MOVIE DETAILS
(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 )