Question: Consider the relation R(A, B, C, D, E) with the following set F of functional dependencies. F = {{A} {B}, {B} {B, C}, {C} {A,

Consider the relation R(A, B, C, D, E) with the following set F of functional dependencies.

F = {{A} {B}, {B} {B, C}, {C} {A, B, C}, {A} {C, D}, {D, E} {D}}

13. Which of the following functional dependencies is in F+ and violates 3NF for R with F?

{C} {A}

{C} {A, B, C}

{A, B, C, D, E} {D}

{B, E} {D}

{A, B, C} {D}

14. Which of the following functional dependencies is in F+ and violates 2NF for R with F?

{B} {D}

{B} {A}

{B} {C}

{C} {B}

{A} {C}

15. Which of the following functional dependencies is projected on the fragment R1(A, C, D, E) of R with F?

{D} {E}

{D} {C}

{D, E} {A}

{D, E} {C}

{C} {A}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!