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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started