Whats Database Normalization ?
Normalization is the process where a database is designed in a way that removes redundancies, and increases the clarity in organizing data in a database. In easy English, it means take similar stuff out of a collection of data and place them into tables. Keep doing this for each new table recursively and you’ll have a Normalized database. From this resultant database you should be able to recreate the data into it’s original state if there is a need to do so. The important thing here is to know when to Normalize and when to be practical. That will come with experience. For now, read on… Normalization of a database helps in modifying the design at later times and helps in being prepared if a change is required in the database design. Normalization raises the efficiency of the datatabase in terms of management, data storage and scalability. Now Normalization of a Database is achieved by following a set of rules called ‘forms’ in creating the database. These rules are 5 in number (with
