Other Example
•
R(
A,B,C,D
)
A
B,
B
C
•
•
Key:
A, D
•
Violations of BCNF:
A
B,
A
C,
A
BC
•
Pick
A
BC
:
split into
R1(
A,BC
)
R2(
A,D
)
•
What happens if we pick
A
B
first ?