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

are given:

$2$

First normalization is already met.

$($i$)$ Draw diagram:

in a big box blc it

is a comporite key.

This occurs when an $($non$)$

a trribute that is not

part of a Ck depends on

peart of a composite hey

pery non prime

trioure must depend on the whole key.

J

$DIJ$

P

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$

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

R$1$

R$2$

R$3$

R$3$

R$4$

R$5$ hello i need help on filling in the boxes for $2$NF it has to be R$1$: $3$ boxes, R$2$: $5$ boxes, R$3$ BFGH$.$ for $3$NF R$1$: $3$ boxes, R$2$: $3$ boxes, R$3$: $3$ boxes, R$4$: $2$ boxes, R$5$: $3$ boxes. For $2$NF i got ABC ADEIJ BFGH not sure if this is right. for $3$NF i am lost