Normalization Of Database Tables – Coursework Example
Normalization of Database Normalization of Database Advantages of Normalization It minimizes modification anomalies. Modification anomalies emanate from data update, insertion, or deletion and may lead to sudden loss of information.
It results into an organized database. Data organization makes work easier for everyone who uses the database to the database administrator who manages the overall database.
It reduces data redundancy. By minimizing data redundancy, normalization simplifies data structures leading to optimum utilization of disk space.
It enhances database consistency. Normalization helps in keeping duplicate data as low as possible, thus reducing the chances of having inconsistent data within the database. Removing duplicate data leads to disk space conservation.
It leads to improved database security. Normalization creates a better platform to handle the security aspect of a database (Garmany, Walker & Clark, 2005).
It creates a flexible database design, for example, it is much simpler to modify a smaller table compared to larger table with massive data.
Disadvantages of Normalization
Normalization lowers database performance (Coronel & Morris, 2014). This is one of the biggest drawbacks of normalization of database. A normalized data needs more use of CPU, memory as well as input/output in order to process transactions and queries to the database.
There is need for more joins to access the records that the application requires in order to properly function. A normalized database has to locate the tables that have been request then proceed to join the data contained in the tables in order to process the required data or obtain the needed information.
Normalizing of database comes with higher maintenance overhead.
In cases where database performance is the main focus, normalization might not be ideal because it lowers the performance level.
Garmany, J., Walker, J. & Clark, J. (2005). Logical Database Design Principles. Boca Raton: CRC Press.
Coronel, C. & Morris, S. (2014). Database Systems: Design, Implementation, & Management. New York, NY: Cengage Learning.