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

ACID and calibration - Assignment ExampleEqually, Isolation states that the concurrent occurrence of multiple proceeding should not impact each others transactions. Finally, Durability guarantees that any modifications to the database argon not lost.Normalization is a method of reducing or removing data redundancies in the database. Four goals are attained by and by 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 jazz data. Thirdly, there is the building of a database in which manipulation and access to data is rapid and proficient, while silence 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 be 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 cost required to implement, and extra skill requirement to offer functional views and maintain the database. In addition, extra skills are needed to create OLAP