Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

a) Is it correct to assign Movie_ID as the primary key in the MOVIE relation? If no, then suggest an appropriate primary key. b) Is it correct to assign AudiNo as the primary key in the AUDI relation? If no, then suggest appropriate primary key. c) Is there any foreign key in any of these relations? Student Project Database Table: STUDENT Roll No Name Class Section Registration_ID 11 Mohan XI 1 IP-101-15 12 Sohan XI 2 IP-104-15 21 John XII 1 CS-103-14 Table: PROJECT ASSIGNED 22 Meena XII 2 CS-101-14 Registration_ID ProjectNo 23 Juhi XII 2 CS-101-10 IP-101-15 101 Table: PROJECT IP-104-15 103 ProjectNo PName SubmissionDate CS-103-14 102 101 Airline Database 12/01/2018 CS-101-14 105 102 Library Database 12/01/2018 CS-101-10 104 103 Employee Database 15/01/2018 104 Student Database 12/01/2018 105 Inventory Database 15/01/2018 106 Railway Database 15/01/2018 12. For the above given database STUDENT-PROJECT, answer the following: a) Name primary key of each table. b) Find foreign key(s) in table PROJECT-ASSIGNED. c) Is there any alternate key in table STUDENT? Give justification for your answer. d) Can a user assign duplicate value to the field RollNo of STUDENT table? Jusify. 13. For the above given database STUDENT-PROJECT, can we perform the following operations? a) Insert a student record with missing roll number value. b) Insert a student record with missing registration number value. c) Insert a project detail without submission-date. d) Insert a record with registration ID IP-101-19 and ProjectNo 206 in table PROJECT-ASSIGNED. 130 C omputerScience- ClassXII Reprint 2026-27