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

(a) Identify the candidate key(s) from the table MOVIE DETAILS. 

Answer

MOVIEID and TITLE 

Explanation:

  Candidate Key is a super key with no repeated attributes .  A table can have multiple candidate keys but only a single primary key . 

MOVIEID and TITLE for each movie(row) are unique and not repeated.

(b) Consider the table SCHEDULE given below: Table: SCHEDULE 

Which field will be considered as the foreign key if the tables MOVIE DETAILS and SCHEDULE are related in a database?

Answer

MOVIEID