Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Structured Search For Big Data From Keywords To Key-objects

Authors: Mikhail Gilula

1st Edition

012804652X, 9780128046524

More Books

Students also viewed these Databases questions