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

Read questions and write answer about a few sentences Assignment - 3

Read questions and write answer about a few sentences - Assignment Example Statistical research involves the collection, interpretation, organization, analysis, and presentation of the data. In this case, statistical research requires careful planning of time and budgeting of resources involved in a successful outcome. In the article WSJ, the author takes us through two weddings based on the financial input. The expensive one does not result in a successful marriage while the less expensive one in most cases makes a successful marriage. Consequently, it can be concluded that what results from a successful statistical research are careful planning and wise spending of the available resources (Arends 3). In an article from Fivethirtyeight.com, the author revealed how the census bureau does clean their messy data. He claimed that the bureau do revise their data where they identify the possible errors in the name of the people by using an algorithm. In the event that a couple who is registered as an opposite sex couple but the name registered under male section appears to be a female name, the bureau considers the individual as the woman. Therefore, they assume that the couple is of the same sex hence changes its registration to same-sex marriage. The bureau argues that though doing this is unethical; the overall effect is minimal since it makes their data more accurate and realistic (Casselman). In the article written for GSA, the insights that I got concerning writing a recommendation letter is that it must be brief and in support of the candidate by emphasizing on the strengths, characters and weaknesses of the candidate. In regards to the other article designed for the students, the insights that come out clear are building rapport with the relevant professor and seeking for the recommendation letter in advance of the due