Explain BCNF, 4NF, and 5NF. When do you normalize beyond 3NF?

Answer preview

BCNF, 4NF, and 5NF are stricter forms that catch redundancy 3NF still allows. BCNF fixes functional dependencies whose determinant is not a candidate key, 4NF removes independent multi-valued facts crammed into one table, and 5NF removes join dependencies where a three-way table …