The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
16 views

PLEASE SOMEONE EXPLAIN ME THAT WHY 2ND OPTION IS TRUE ? I AM NOT GETTING THIS OPTION HELP ME

 

R(A,B,C,D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition?

  1. A→B,B→CD
  2. A→B,B→C,C→D
  3. AB→C,C→AD 
  4. A→BCD
asked in Databases by Active (3.2k points) | 16 views
0
Is the answer option 3?
0
yes but please explain me 2nd option
+1
The BCNF decompostion of option 2 will be R1(A,B), R2(B,C) and R3(C,D).

We can see that these three relations are lossless (by drawing table).For dependency preserving, from R1 er get the fd A->B, from R2 we get B->C and from R3 we get C->D.Thus we can obtain all the FDs and hence the relation is dependency preserving
0
ok ok got it thanku bro

Please log in or register to answer this question.



Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

40,928 questions
47,581 answers
146,441 comments
62,311 users