joinrelational-databasedatabase-normalizationnatural-join

Lossless Join Property


What is meant by the lossless join property in a relation schema?

Is it the ability to maintain the semantics of information/data during the decomposition of relations whilst normalising?


Solution

  • The lossless join property is a feature of decomposition supported by normalisation. It is the ability to ensure that any instance of the original relation can be identified from corresponding instances in the smaller relations.