Register

Meaning of this

281 views

1 Answer

3 votes
3 votes
BEcoz we r decomposing the relation into more than one . so now we have more probable chance to have either a super key or prime attribute in any fuctional dependecy in a particular relation . so which is a small relaxation for BCNF
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
kallu singh asked Nov 9, 2017
7,154 views
Please solve this Q
Question: 6 Given the following functional dependencies {X → W, X → Y, Y → Z, Z → PQ} Consider the FD set implied using above FD set. Implied FD set = {X → Z, X → WY, X → WZ, X → YQ, Y → P} The number of functional dependencies in implied FD set are invalid are _________.
Question: 6 Given the following functional dependencies{X → W, X → Y, Y → Z, Z → PQ}Consider the FD set implied using above FD set.Implied FD set = {X → Z, X �...
User Avatar
1 votes
1 votes
1 answer
3
Shefali asked Jul 23, 2015
4,842 views
A relation R(ABCDE) with FD set f = {A -> BC, C -> DE, D -> E} and the decomposition d = { R1(ABCD), R2(DE)}. Is this decomposition dependency preserving?
The answer given is YES. But how is the dependency C - DE preserved in this decomposition?
User Avatar
Link Copied!