Database Normalisation Questions
The process of decomposing a relation in database normalization is known as functional dependency decomposition. It involves breaking down a relation into multiple smaller relations to eliminate redundancy and improve data integrity. This is achieved by identifying functional dependencies within the relation and creating separate tables for each dependency. The goal is to ensure that each relation contains only atomic values and that data is stored in the most efficient and organized manner.