NORMALIZATION EXERCISE -PLEASE NORMALIZE THIS TABLE IN 3NF (AT A MINIMUM 2NF) ce Name Departmen FRAG Rama dministrator AR The process may look complicated. However, if you follow the rules completely, and donot miss out any steps, then you should arrive at the correct solution. If you omit a rule there is a high probability that you will end up with too few tables or incorrect keys The following normal forms were discussed in this section: 1. First normal form: A table is in the first normal form if it contains no repeating columns 2. Second normal form: A table is in the second normal form if it is in the first normal form and contains only columns that are dependent on the whole (primary) key 3. Third normal form: A table is in the third normal form if it is in the second normal form and all the non-key columns are dependent only on the primary key. If the value of a non- key column is dependent on the value of another non-key column we have a situation known as transitive dependency. This can be resolved by removing the columns dependent on non-key items to another table