Decompositions in General

A , A , … A

1

2

n

Let R be a relation 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

And

-- R1 is the projection of R on

-- R2 is the projection of R on

B , B , … B

1

2

m

C , C , … C

1

2

l

Previous slide

Next slide

Back to first slide

View graphic version