Question No: $05$

This is a subjective question, hence you have to write your answer in the Text$-$Field given below.

Consider the three relations Student, Course, Student$\_$Course given below. Given that StudID is the primary key of Student, Rollno and StudPANNo are the unique keys of Student relation, Cid is the primary key of Course, and there is a referential integrity between Course.CID and Student.CID $($Student$.$CID refers Course.CID$).$ And we have a relationship relation Student$\_$Course from M:N relationship between Student and Course, and its primary key is combination of CID and StudID.

Discuss the integrity constraints$($at least $5)$ that are violated.

$[5$ Marks$]$

Course

$\backslash$table$[[$CID$,$CourseName,CourseBook$],[$C$1,$Comp Programming,Ritchie$],[$C$2,$DBDA,Null$],[$C$1,$Data Mining,Null$],[$C$3,$Data Mining,Tan$],[$C$4,$DBDA,Navathe$],[$C$5,$NULL,RRKG$],[$Null$,$Relational Databases,Korth$]]$

$\backslash$table$[[$StudID$,$Studname,StudBranch,Rollno,CID,StudPANNo$],[1,$Anita,CSE,$1239,$C$1,$AGBPk$9978]],[$Null$,$Meenu,Null,$1234,$C$2,$AmGHN$887$H$],[$S$1,$Anita,CSE,$1239,$C$6,$AL$6$NL$8879$H$],[$S$3,$Raghu,ECE,$1245,$C$4,$NULL$],[$S$4,$Manu,CSE,$1246,$C$2,$AGBPk$9978]]]$

Student$\_$Course

$\backslash$table$[[$StudID$,$COurseID$],[$S$2,$C$1],[$Null$,$C$1],[$S$1,$C$1],[$S$3,$C$2],[$S$4,$C$2]]$