Q$2.$ Consider the following three relations with the following correct information.

$(3$ Pnts$)$

$\backslash$table$[[$Student$,$Advisor,Adv$\_$Maj$],[$SNo$,$SName,ANo,Major,ANo,AName,ANo,Major,Year$],[$S$1,$Tom,A$1,$MIS,A$1,$Bill,A$1,$MIS,$1993],[$S$2,$Dick,A$1,$MIS,A$2,$pete,A$2,$FIN,$1992],[$S$3,$Sandy,A$2,$FIN,A$3,$Cathy,A$2,$ACCT,$1990],[$S$3,$Sandy,A$2,$ACCT,A$4,$Dick,A$3,,1996],[$S$4,$Kim,,,,,A$5,$MKT$,1985]]$

ANo of Ady Maj is a foreign key referencing the Advisor relation.

$($ANo$,$ Major$)$ of Student is a foreign key referencing the Adv Maj relation.

Year of Adv$\_$Maj must be $1990.$

The content $($tuples$)$ of the three relations violate some of relational model constraints

$($Domain$,$ Key, Entity Integrity, and Referential Integrity$)?$

List all of these violations by completing the following table with relation name, constraint name violated, and tuples that violate the constraints.