1. First normal form:
The first step in normalisation is putting all repeated fields in separate files and assigning appropriate keys to them.
2. Second normal form:
In this stage of normalisation, all non-key elements that are fully specified by something other than the comÂplete key are placed in a separate table. Normally, these non-key elements are dependent on only a part of a compound key.
3. Third normal form:
This stage of normalisation enables elimiÂnating redundant data elements and tables that are subsets of other tables. The redundant elements are those non-key data elements that are placed in more than one table of the virtual data elements.
