Suppose the following relation $($schema$)$ R and functional dependencies F are given:

$R(A,B,C,D,E,F,G,H,$I,$J)$

$F=(ABC,ADE,BF,FGH,DIJ)$

Assume that the first normalization form is already met. Before applying database normalization, please

draw a normalization diagram we did in class first. Then, decompose it to satisfy the second and third

normalization forms by filling out each relation table below.

Answer

Normalization Diagram $(4$ points$)$

$2$NF $(12$ points$)$

R$1$

R$2$

R$3$

$3$NF $(14$ points$)$

$2$NF $(12$ points$)$

R$1$

R$2$

R$3$

$3$NF $(14$ points$)$

R$1$

R$2$

R$3$

R$4$

R$5$

Asvignment #$2$

The following schema $R$ and functional dependencies $F$

are given:

First normalization is already met.

Dra$($s$)$ diaaram:

a big box b$/$cis is

a composite key.

$(2)2NF$ we must eliminate partial dependencies

snows $C$ depends on A determines both $D+.B$ determines $F,$ and $F$

Ith AdB together. Include all other attribues determines GioH.

$114$

$116$ VALUES $(\text{'}453453453\text{'},\text{'}2\text{'},\text{'}20\mathrm{.}0\text{'})$:

$117$

$119$ VALUES $(\text{'}3334455555\text{'},\text{'}2\text{'},\text{'}10\mathrm{.}0\text{'})$;

$120$

$122$ VALUES $(\text{'}333445555\text{'},\text{'}3\text{'},\text{'}10\mathrm{.}0\text{'})$s

$123$

$125$ VALUES $(\text{'}333445555\text{'},\text{'}10\text{'},\text{'}10\mathrm{.}0\text{'})8$

$128$ VALUES $(\text{'}333$M$95555\text{'},\text{'}20\text{'},\text{'}30\mathrm{.}0\text{'})8$