Week 5 & 6 - NORMALIZATION

   For week 5 and 6 , The main things which we were munching on was Normalization. Normalization is typically a refinement process after the initial exercise of identifying the data objects that should be in the database, identifying their relationships, and defining the tables required and the columns within each table. In short , in the process of transforming an unnormalized table into a more better and systematic table.

   I also learned about dependencies in a table. There are 2 types of dependencies , Partial dependency and transitive dependency. Partial dependency is there when a primal attribute is dependent on a non-primal attribute . While Transitive dependency is there when a non-primal attribute is dependent on another attribute which is the same type. The main goal of Normalization is to transform a unnormalized table to be a 3NF