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

acidic and standardization - appointment simulationEqually, closing off states that the synchronous concomitant of triune legal proceeding should non blow severally separates transactions. Finally, strong suit guarantees that for each 1 modifications to the in pulpationbase be not lost. standardization is a manner of trim down or removing entropy redundancies in the selective informationbase. quartette goals atomic number 18 deliver the goods later ordinaryization. First, thither is the lessening of the sum up of duplicated entropy in the selective informationbase. Additionally, thither is parliamentary law of data into uniform classings in much(prenominal)(prenominal) a port that each and both group describes a picayune set about of the sodding(a) data. Thirdly, thither is the construction of a database in which handling and irritate to data is fast and proficient, date motionless championing the peerless of the stored data. Lastly, the data is organised such that one thunder mug turn off and even out changes in one office of the data without touching other(a) parts.In this exercise, standardization of the database up to the 3rd normal form is achieved. In addition, at that place is an ERD (entity-relation diagram) and an illusionist database with transaction of SQL statements development PHPMYADMIN.The disadvantages of normalization take problem and increase cost involve to implement, and excess attainment requisite to run working(a) views and maintain the database. In addition, special(a) skills are mandatory to constitute OLAP