Question

R = {Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9,QJ} Given these functional dependencies:

{Q5,Q6} > {Q7}

{Q5} > {Q8,Q9}

{Q6} >  {QJ}

{QJ} >  {Q1, Q2}

{Q8} >  {Q3, Q4}

{Q3} > {Q7, Q1, Q2, Q5, Q6}

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 your 2NF table is not in 3NF. Make the required adjustments to convert table to 3NF

Answer 1

Sol (a) od stuwo Prman Keys. ΐς made exp ef. only one attribute , no oter. attvibute can be Patfalty derendent en e Primery ke. Ri not because. ·収9, by paatiatly dependent nes, are р., (gs,Q8,6Ml@u) R21Q3 They ae al NF but R21 fc not3If because 2212(8, Q) R22 ( ат)