Relation Decomposition

A , A , … A

1

2

n

Given a relation R with attributes

Create two relations R1 and R2 with attributes

B , B , … B

1

2

m

C , C , … C

1

2

l

Such that:

B , B , … B

1

2

m

C , C , … C

1

2

l

?

=

A , A , … A

1

2

n

Can we always decompose a relation with no dire consequences?

When we see a BCNF violation, how do we decompose?

Next slide

Back to first slide

View graphic version