paraphrase

profileazzzzzz129

  

First Normal Form (1NF): 

1NF is the first step in normalization which focuses on the shape of a record type. All the occurrences of record type must have the same number of fields. The values should not be repeated. For example, we cannot have one field for addresses because it contains more than value. We cannot have one value that contains numbers and another value contain letters in the same column. All the values should hold the same kind. Moreover, cannot have a complete identical row because every entire row should be unique.

Second Normal Form (2NF): 

The 2NF simply deals with partial dependencies. What that means is that 2NF is reached when it is already in 1NF and when we fix the relations between key fields and non-key fields. In 2NF we should look for what PKs determine from the non-keys to fix them by break them down to separate tables and remove them from the original one. 

Third Normal Form (3NF): 

3NF is reached when it is already in 2NF and have the transitive dependencies fixed. Once we have non-keys determine other non-keys, we should remove them from the table and draw them in a separate table. 

Boyce-Code Normal Form (BCNF): 

Continually, we can reach BCNF when we already in 3NF and have functional dependencies fixed. It is when a non-key determines a part of a composite key. Substitution works in this situation. 

Fourth Normal Form (4NF): 

If we are already in BCNF, and we have no multivalued dependencies other than a candidate key

Fifth Normal Form (5NF):  The table will be in 5NF if it is already in 4NF and has no join dependency. When we have our original tables broken down to separate tables for some purposes, we should get to the exact original one by the time we join the separate tables in order to reach 5NF.  

    • 8 years ago
    • 10
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      DatabaseNormalization.docx