What is a 'normalform' in a database?

Database Normalisation

Normal form (NF) is a state desired by database admins. It exhibits proofs that the designed system files or tables do not contain any duplicated fields.

To achieve the desired NF, designers need to assess the dependencies of fields (info) in relation to others. This is done trough Normalisation process, starting from 3rd normal form down to 2nd normal form. Normal form (ie. 1st NF) is reached when fields are no longer duplicated and optimally selected as table unique keys.

Improve Answer Discuss the question "What is a 'normalform' in a database?" Watch Question

First answer by Azhoo. Last edit by Azhoo. Contributor trust: 33 [recommend contributor]. Question popularity: 31 [recommend question]

Research your answer:

Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > What is a 'normalform' in a database?

Our contributors said this page should be displayed for the questions below. (Where do these come from)
If any of these are not a genuine rephrasing of the question, please help out and edit these alternates.
What is a normalform in database?