Another advantage of normalization is that it provides indexing. Indexing speeds up the access of data, increase delete, update, and insert performance. Normalization also minimizes modification anomalies. Modification anomalies can occur when the data is deleted, inserted, or updated, and the data is lost in other ways such as hardware being damaged or stolen. In addition, normalization helps with the reduction of table and row size. Creating primary and foreign key constraints will reduce the number of empty or null values in columns and reduces the overall size of the database. Normalization has yet another great advantage, referential integrity. Referential Integrity means that one column
in a table has to relate to a column in another table. It is the ability to take important information or relate data from one table to another through a similar attribute. For example, in order for an employee to have a record in the PAY_TBL table, that employee would have to have a record in the EMPLOYEE_TBL table. Referential... [continues]
Cite This Essay
(2008, 10). Advantages and Disadvantages of Normalization. StudyMode.com. Retrieved 10, 2008, from http://www.studymode.com/essays/Advantages-And-Disadvantages-Of-Normalization-173830.html
"Advantages and Disadvantages of Normalization" StudyMode.com. 10 2008. 2008. 10 2008 <http://www.studymode.com/essays/Advantages-And-Disadvantages-Of-Normalization-173830.html>.
- MLA 7
"Advantages and Disadvantages of Normalization." StudyMode.com. StudyMode.com, 10 2008. Web. 10 2008. <http://www.studymode.com/essays/Advantages-And-Disadvantages-Of-Normalization-173830.html>.
"Advantages and Disadvantages of Normalization." StudyMode.com. 10, 2008. Accessed 10, 2008. http://www.studymode.com/essays/Advantages-And-Disadvantages-Of-Normalization-173830.html.