The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
19 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 (4.9k points) | 19 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.

Related questions

+1 vote
0 answers
4
asked Oct 22, 2017 in Digital Logic by Ipsita Priyadarsini (215 points) | 87 views
0 votes
0 answers
5
asked Sep 30, 2017 in Digital Logic by Kuldeep Pal Active (1.4k points) | 79 views


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

44,072 questions
49,594 answers
162,957 comments
65,788 users