Normalization In Database Management Systems
So what does Normalization look like? There are four levels called first, second, third and fourth normal forms. First Normal (1NF) requires the database to have no repeating groups and must identify all the key attributes that are dependent on the primary key. The second form (2NF), requires being in 1NF and additionally has no attributes dependent on only a portion of the primary key. Thirdly, third form (3NF) is in 2NF and also contains no transitive dependencies while the last normal form eliminates multivalued dependencies in a database.
Normalization begins with the first step 1NF, which comes after studying the data. Here the design analyst identifies and eliminates all the attributes that will end up repeating themselves in a table. An example of this would be StudentID, Student_State, and ClassID, where Student_State will end up repeated in all the same fields that StudentID has multiple …show more content…
Without normalization a firm would likewise find it difficult to identify bad data anomalies and additionally would find searching through its records impractical if large amounts of data were stored. An example of the lack of normalization can be seen with the IRS in the 2000s where because of the lack of normalization simple queries for information might take months to perform because the system had no relationships to speed the search, effectively making the server use recursive logic from the top row all the way down the hundreds of millions or rows of