Lossless join decomposition
DECOMPOSITION OF A DATABASE RELATION SUCH THAT A NATURAL JOIN OF THE RESULTING RELATIONS YIELDS BACK THE ORIGINAL RELATION
Lossless-join decomposition; Lossless-Join Decomposition
In database design, a lossless join decomposition is a decomposition of a relation R into relations R_1, R_2 such that a natural join of the two smaller relations yields back the original relation. This is central in removing redundancy safely from databases while preserving the original data.