VOOZH about

URL: https://www.geeksforgeeks.org/questions/let-r-a-b-c-d-be-a-relational/

⇱ GATE | IT | 2008 | DBMS | Functional Dependency | Question 59

Last Updated :
Discuss
Comments

Let R (A, B, C, D) be a relational schema with the following functional dependencies: 

A → B, B → C,
C → D and D → B. 

The decomposition of R into 
(A, B), (B, C), (B, D)

gives a lossless join, and is dependency preserving

gives a lossless join, but is not dependency preserving

does not give a lossless join, but is dependency preserving

does not give a lossless join and is not dependency preserving

This question is part of this quiz :

Gate IT 2008
Tags:
Share your thoughts in the comments
GeeksforGeeks