Question $2.$

Consider the following relations:

Relation R$1$

Relation R$4$

Relation R$2$

Relation R$5$

Relation R$3$

Primary Keys :

Relation R$1$: A$,$B

Relation R$2$: D

Relation R$3$: $M,N,O$

Relation R$4$: $J,K$

Relation R$5$: $S$

The following foreign key constraints are given for relations $R1,R2,R3,R4$ and $R5$ :

$R3(MN)$ references $R1(AB)$

$R3(O)$ references $R2(D)$

$R1(C)$ references $R5(S)$

$R4(J)$ references $R5(S)$

$R4(K)$ references $R2(D)$

Assume

"CASCADE" policy for delete operations, and

"SET NULL" policy for update operations.

a$)(10\%)$ For the operations given below, indicate whether execution of the operation would

violate some "primary key" or "integrity constraints". If your answer is yes, specify the

constraints $($from the above list$)$ that would be violated.

i$)$ Insert tuple $(a1,b10,d20,35)$ into R$3.$

ii$)$ Insert tuple $(5500,d20,75)$ into R$4.$