|< < 10 > >|

Lossless join decomposition

Decompositions are not always lossless.

Example

XYZ

X Y Z
1aaa666
1bbb777
2aaa777


XY = project(XYZ, [X, Y])

X Y
1aaa
1bbb
2aaa

XZ = project(XYZ, [X, Z])

X Z
1666
1777
2777

|< < 10 > >|