Decomposition in DBMS – Lossless and Lossy
Decomposition means dividing a large and complex table into multiple small and easy tables. This removes redundancy, anomalies, and inconsistency in a database. This is the first stage of normalization. Suppose we have a relational schema R, in which we have attributes as given below: A1, A2, A3…………An So R = {A1, A2, A3…………An} If …