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

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

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

Systems Analysis And Synthesis Bridging Computer Science And Information Technology

Authors: Barry Dwyer

1st Edition

0128054492, 9780128054499

More Books

Students also viewed these Databases questions

Question

Explain the role of geographic regions as subcultures?

Answered: 1 week ago

Question

l Define training and identify two types of training.

Answered: 1 week ago

Question

Describe Table Structures in RDMSs.

Answered: 1 week ago