ACID and Normalization Assignment Example | Topics and Well Written Essays - 750 words

ACID and Normalization - Assignment Example Equally, Isolation states that the concurrent occurrence of multiple transactions should not impact each other’s transactions. Finally, Durability guarantees that any modifications to the database are not lost. Normalization is a method of reducing or removing data redundancies in the database. Four goals are attained after normalization. First, there is the reduction of the number of duplicated data in the database. Additionally, there is ordering of data into logical groupings in such a way that each and every group describes a small part of the complete data. Thirdly, there is the building of a database in which manipulation and access to data is rapid and proficient, while still maintaining the integrity of the stored data. Lastly, the data is organized such that one can edit and make changes in one part of the data without affecting other parts. In this exercise, normalization of the database up to the third normal form is achieved. In addition, there is an ERD (entity-relation diagram) and an Oracle database with execution of SQL statements using PHPMYADMIN. The disadvantages of normalization include difficulty and increased costs required to implement, and extra skill requirement to offer functional views and maintain the database. In addition, extra skills are needed to create OLAP