DBMS Notes

Lossless Decomposition

  • If the information is not lost from the relation that is decomposed, then the decomposition will be lossless.
  • The result of lossless decomposition after natural joins will be the exactly same relation as it was before the decomposition.

EMPLOYEE_DEPARTMENT table:


EMPLOYEE Table:
The above table is decomposed into two relations EMPLOYEE and DEPARTMENT

Table 01: EMPLOYEE

Table 02: DEPARTMENT

Now, Above two tables are joined on the common column “EMP_ID”. 

 Employee ⋈ Department

As above table is the original table as it was before decomposition, Hence, the decomposition is Lossless join decomposition.

Help Other’s By Sharing…

Contact Us

Burewala, Vehari, Punjab, Pakistan

cstaleem1@gmail.com

Website: CStaleem.com

Pin It on Pinterest