using sql:

Create two tables named assignment$\_$r and assignment$\_$s that are defines as follows:

a$.$ Relation assignment$\_$r has attributes $($A$,$ B$,$ C$,$ D$),$ the domains of $($char$(1),$ int, varchar$(5),$ float$)$ respectively.

i$.$ Attribute B is the primary key for this relation

ii$.$ Relation assignment$\_$r has the following tuples as values

$($a$,10,$hello,$10\mathrm{.}5)$

$($b$,1,$hi$,12)$

$($x$,2,$g$479,1102\mathrm{.}3)$

$($c$,101,$geog$1,11)$

$($s$,10,$geog,$12)[$This should cause an error$]$ Explain why this error

occurs

$($y$,123,$g$,12\mathrm{.}5)$

b$.$ Relation assignment$\_$s has attributes $($B$,$ D$,$ E$),$ the domains of $($int$,$ float, char$(1))$ respectively.

i$.$ Attribute B is the primary key for this relation

ii$.$ Relation assignment$\_$s has the following tuples as values

$(100,10\mathrm{.}5,$s$)$

$(1,12,$z$)$

$(2,1\mathrm{.}3,$g$)$

$(103,1\mathrm{.}1,$y$)$

$(10,12,$s$)$