Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables into smaller tables and links them using relationships.
BCNF is stricter than 3 NF
Lossless, dependency -preserving decomposition into 3 NF is always possible
Loss less, dependency – preserving decomposition into BCNF is always possible
Any relation with two attributes is BCNF
We say that the decomposition is a lossless decomposition if there is no loss of information by replacing r (R) with two relation schemas r1(R1) andr2(R2).