Reference no: EM132271524

R = {T1,T2,T3,T4,T5,T6,T7,T8,T9,TJ}

Given these functional dependencies:

{T5,T6} > { T7}

{T5} > { T8,T9}

{T6} > { TJ}

{TJ} > { T1, T2}

{T8} > { T3, T4}

{T3} > { T7, T1, T2, T5, T6}

a. Identify 2 primary keys to this table.

b. Assuming it is in 1NF, explain why it is not in 2NF. Make the required adjustments to convert table to 2NF. Show primary key of each table.

c. Assuming it is in 1NF, explain why the 2NF table is not in 3NF. Make the required adjustments to convert table to 3NF.