Normalization Slides for HSSC/SSC Students

Normalization

1. First Normal Form Remove repeating values in a cell Remove Repetition of rows

2. Normalization Database normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity. It was first proposed by British computer scientist Edgar F. Codd as part of his relational model.

3. EmpNum EmpPhone EmpDegrees 123 233-9876 333 233-1231 BA 333 233-1231 BSC 333 233-1231 Phd 679 233-1231 Bsc 679 233-1231 Msc

4. 2 nd Normal Form Remove repeating values in a cell Remove Repetition of rows