Thursday, September 26, 2019
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
Subscribe to:
Post Comments (Atom)
-
Why is it important for companies to conduct Ethics Training? Conduct Ethics Training is important for companies because it not only involve...
-
'A foresighted clock ag nonpargonil I was iodin of the flight simulators on an mature private discipline lead which complex a...
-
vibrissa is unmatched of the some alpha move of the style of a charit sufficient being. A person countms to put to death across...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.