Reference no: EM132270044

Database Normalization Question:

Given Relation X = (D0,D1,D2,D3,D4,D5,D6,D7,D8,D9) and given these functional dependencies:

{D1,D2} -> {D3}

{D1} -> {D5,D6}

{D2} -> {D6}

{D6} ->{D7,D8, D9}

{D4} -> {D1, D0, D5}

{D0} -> {D3}

a. Determine the Primary Key of R (5 points).

b. Can you tell if this table is in first normal form?

c. Place R into 2nd Normal Form including the key of each table?

d. Place R into 3rd Normal Form including the key of each table?