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