Explain the Levels Normalization Process?
First Level : Eliminate repeating of groups of data in each table by creating separate tables for each group of related data. Identify each set of related data with a primary key Second Level : Releate tables using Foreign key Third Level : Eliminate fields/columns that do not depend on the key Fourth Level: in many-to- many relationship independent entites cannot be stored in the same table (most developers ignore this rule) Fifth Level : the Original Table must be reconstructed from the tables into which it has been broken down. Its only useful when dealing with large data schema Zero Form : If a DB which does not complains to any of the Normalization forms. This type is usefull only for data ware housing.
