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}}

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

{C} {A, C}

{E} {A}

{D, E} {A}

{E} {D, C}

{D} {C}

17. Which of the following is a lossless dependency-preserving decomposition of R with F in BCNF?

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

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

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

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

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

18. Which of the following is a lossless dependency-preserving decomposition of R with F in 3NF?

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

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

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

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

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

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!