Saved Bookmarks
| 1. |
Consider the table, MOVIEDETAILS given below:Table: MOVIEDETAILSMOVIEIDTITLELANGUAGERATINGPLATFORMM001MinariKorean5NetflixM004MGR MaganTamil4HotstarM010KaagazHindi3Zee5M011Harry Potterand theChamber of SecretsEnglish4Prime VideoM015UriHindi5Zee5M020Avengers: EndgameEnglish4Hotstar(a) Identify the degree and cardinality of the table. (b) Which field should be made the primary key? Justify your answer.OR(a) Identify the candidate key(s) from the table MOVIEDETAILS. (b) Consider the table SCHEDULE given below:Table: SCHEDULESLOTIDMOVIEIDTIMESLOTS001M01010 AM to 12 PMS002M0202 PM to 5 PMS003M0106 PM to 8 PMS004M0119 PM to 11 PMWhich field will be considered as the foreign key if the tables MOVIEDETAILS and SCHEDULE are related in a database? |
|
Answer» (a) Degree: 5 Cardinality: 6 (b) MOVIEID should be made the primary key as it uniquely identifies each record of the table. OR (a) MOVIEID and TITLE (b) MOVIEID |
|