Normalization
Normalization Ø It is process of minimize the redundancy. Redundancy means duplication of data. Ø It divides larger table into smaller tables and links them using relationship. Ø Example Empid Ename Sal Deptname Location 101 Ramu 10000 IT Hyd 102 Kamal 14500 Account Mumbai 103 Satish 15000 Account Mumbai 104 Praveen 16500 IT Hyd Empid Ename Sal Deptno 101 Ramu 10000 10 102 Kamal 14500 20 103 Satish 15000 20 104 Praveen 16500 10 ...