Service Request Sr-Ht-003

Service Request SR-ht-003

DBM/380

Principle and Importance of Normalization

The database normalization is a technique that is used to organize the contents in the tables for transactional databases and also data warehouses. The normalization is a portion of designing the database with success, without this the database systems may be inaccurate, inefficient, slow, and they may not create the data that is expected. Following a SQL Server installation that is successful a database will need to be created that will hold the data. After the database framework has been created, the files must be organized in a way that can be easily managed. The primary tool that will help organize the data will be the table that will look like a two-dimensional structure that encompasses rows and columns. When the database is normalized there will be four goals to maintain. These goals will be to organize data in logical groupings that each group will describe a small part of the whole; lessening the amount of duplicated data that is saved in the database; organize the data that so that when it is modified the change can be made in only one place; also building a database where the data can be accessed and manipulated quickly, efficiently, and without compromising the integrity of the data that is stored.

The normalization of the data helps to design the new databases so that it will meet the goals and to test the databases to see if the goals are met. The database designers will at times refer to the goals as data integrity, referential integrity, or keyed data access. It will be ideal to normalize the data before the database tables are made.

Data normalization is very important in transactional, or the online transactional processing database world where many data modifications take place constantly and randomly throughout the stored data. In contrast to that, the data warehouse will contain a substantial amount of denormalized and summarized data that is...