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 Adv$\_$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.

$\backslash$table$[[$Relation$,$Constraint,$\backslash$table$[[$Tuple$($s$)$ that$],[$violate$($s$)$ constrain$]],$Justify$],[$Adv$\_$Maj,Domain,$5^{th}$ tuple,$\backslash$table$[[$Year $(1985)$ value is invalid.$],[$Year must be $1990.]]],[,,,],[,,,]]$