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$]$

CourseConsider following three relations Student$(\{$Lname$.$Fname,StudId,Major$\})$ Grades$(\{$StudID$,$CrsId,Grade$\})$ Course$(\{$Cname$,$CrsId,Points,Dept$\})$ You have three relations$($Student$,$Grades and Course$).$ Optimize the following query using optimization heuristics StudId,Lname$($s$.$StudID$=$g$.$StudId $^$ g$.$CrsId$=$c$.$CrsId $^$ Grade $=`$A$+\text{'}^$ Major $=`$Math$\text{'}^$ Dept $=`$Comp$\text{'}($Course x Grades$)))$