Semester 3Database Systems
Dependency Decomposition
Decomposition means breaking down a big relation into multiple smaller ones. This allows mainly to reduce data redundancy and anomalies during normalization processes
When decomposing a relation, we need to consider two main things to avoid breaking the initial relation.