What do you mean by lossless join? How can we test it.
Database Management System
Computer Science Engineering
562
Thomas
Lossless-join decomposition is a process in which a relation is decomposed into two or more relations. This property guarantees that the extra or less tuple generation problem does not occur and no information is lost from the original relation during the decomposition.
For lossless join decomposition, we select a common attribute. Attributes in DBMS are the descriptive properties which describe an entity.
In addition, the following conditions must also be satisfied-
It is also known as non-additive join decomposition. The two main conditions for lossless join decomposition are