1. Introduction a. Normalization is a step by step decomposition of complex records into simple records. b. Normalization results in tables that satisfy some constraints and are simple represented in a manner. c. This process is also called as canonical process synthesis. d. This is a relation database design process to avoid data redundancy by applying some constraints on data to avoid various data anomalies. e. Eg. If some information is repeated in multiple tables of database the there are chances that these tables will not be consistent in case of data updation, insertion or deletion. This instance may lead to problems of data integrity. 2. Definition