What is a 'normalform' in a database? |
[Edit] |
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.
First answer by Azhoo. Last edit by Azhoo. Contributor trust: 33 [recommend contributor]. Question popularity: 31 [recommend question]
|
Research your answer: |



