O'Reilly logo

NHibernate 3 Beginner's Guide by Gabriel N. Schenker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Normal form

To optimize data storage and retrieval, and to avoid errors introduced by redundant data, relational databases normalize data. The process of organizing data to minimize redundancy is called normalization. Edgar F. Codd, the inventor of the relational model, which is the base of relational databases, introduced the concept of normalization. He defined what we now know as the First Normal Form (1NF) in 1970. A year later he introduced and defined the Second and Third Normal Form (2NF and 3NF).

  • 1NF: A table is free of repeating groups.
  • 2NF: Non-key attributes must depend on the whole key.
  • 3NF: Non-key attributes are dependent on "nothing but the key".

To be 1NF compliant, we need to eliminate duplicate columns from the same table, create ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required