Register

Normalization

587 views

1 Answer

Best answer
1 votes
1 votes

In this example, the decomposition is lossless but not dependency preserving.

• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

2 votes
2 votes
2 answers
1
pradeepchaudhary asked Jun 8, 2018
1,800 views
NORMALIZATION
Given: The Relation R(A,B,C,D,E) having (A,B) as Primary key. The set of functional dependencies: (A,C)-->D , (B,D)-->E. I want to Know whether the functional dependencies Given above are Partial FD's or Not?
Given: The Relation R(A,B,C,D,E) having (A,B) as Primary key. The set of functional dependencies: (A,C) >D , (B,D) >E. I want to Know whether the functional dependencies ...
User Avatar
1 votes
1 votes
2 answers
2
aditi19 asked Apr 14, 2019
1,904 views
Molina Exercise-3.3 BCNF decomposition
Decompose into BCNF R(A, B, C, D, E) FD: AB->C, C->D, D>B, D->E
Decompose into BCNFR(A, B, C, D, E)FD: AB->C, C->D, D>B, D->E
User Avatar
3 votes
3 votes
1 answer
3
aditi19 asked Nov 29, 2018
1,158 views
Raghuramkrishnan
R(A, B, C, D) FD: B->C, D->A is the following decomposition in BCNF? R1(B, C), R2(A, D), R3(C, D)
R(A, B, C, D)FD: B->C, D->Ais the following decomposition in BCNF?R1(B, C), R2(A, D), R3(C, D)
User Avatar
2 votes
2 votes
1 answer
4
Na462 asked Jul 14, 2018
1,915 views
BCNF Decomposition
User Avatar
Link Copied!