SQL Database Design » 14. Normalization » 14.3 First Normal Form

14.3 First Normal Form

To reach the first normal form (1NF), just avoid any repeating attributes and collective types. If you are a purist, avoid structured types, too. This will always result in first normal form designs: Tables without multivalued columns are in first normal form (1NF), or normalized. The relational model requires all database tables to be in 1NF, so relational tables are normalized by definition.

Last updated: 2010-08-04