Delhi, India
← Back to DBMS

Lossy / Lossless Dependency Preserving Decomposition

Core CS Notes · DBMS · Topic 5 of 5


Original table decomposed and joined back, producing extra rows

Original Data ko decompose kiya, but, constructing this table again, we have more rows. WHY? A has two values P and R, and everytime A comes, two values are being added. Uniqueness of the original tables has been lost. If more rows / less rows both are loss.

Lossless Decomposition / Non additive Join Decomposition

Incomplete in the original notes: this heading has no content written under it yet.