Don’t even consider designing a database until you understand second normal form and third normal form. And try for third normal form.

Normalization is one of the commandments of IT database pros, whether you are a data modeler, DBA, or SQL developer. Arthur Fuller defines each normal form and explores why most database designers ...

2. What is Boyce and Codd Normal Form? Answer: Boyce–Codd normal form is a normal form used in database normalization. It is a slightly stronger version of the third normal form. BCNF was developed in ...