StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

ACID and Normalization - Assignment Example

Cite this document
Summary
To achieve 2NF, the primary key must establish each non-primary key attribute. I achieved 3NF by resolving all transitive dependencies.
ACID (Atomicity, Consistency, Isolation,…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95.6% of users find it useful
ACID and Normalization
Read Text Preview

Extract of sample "ACID and Normalization"

Download file to see previous pages

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

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“ACID and Normalization Assignment Example | Topics and Well Written Essays - 750 words”, n.d.)
ACID and Normalization Assignment Example | Topics and Well Written Essays - 750 words. Retrieved from https://studentshare.org/information-technology/1670156-acid-and-normalization
(ACID and Normalization Assignment Example | Topics and Well Written Essays - 750 Words)
ACID and Normalization Assignment Example | Topics and Well Written Essays - 750 Words. https://studentshare.org/information-technology/1670156-acid-and-normalization.
“ACID and Normalization Assignment Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.org/information-technology/1670156-acid-and-normalization.
  • Cited: 0 times

CHECK THESE SAMPLES OF ACID and Normalization

Database Design & Development

It is a DBMS that manages… RDBMS is based on the concept of relational system, referential integrity and normalization (Chaterjee 2005).... It is a database management system that is based on a popular model of relational model.... This model was devised by E.... F.... Codd....
4 Pages (1000 words) Essay

Peptic Ulcer Diseases

Antacids work by neutralizing hydrochloric acid and reducing pepsin activity.... Antacids work by neutralizing hydrochloric acid and reducing pepsin activity.... Although suppressive medications provide relief from symptoms and promote endoscopic mucosa healing, it doesn't guarantee normalization of pH level and long-term use might contribute to the reflux of carcinogenic secretions.... Proton pump inhibitors work by blocking the final step of acid production and inhibiting gastric acid secretion by being converted to active metabolites....
1 Pages (250 words) Essay

Drugs That Treat Hepatitis C

Three major classes of interferons with significant antiviral activities are being recognized: In chronic Hepatitis C virus infection, IFN alfa-2B monotherapy (3MU, 3 times a week) is associated with an approximate 50-70% rate of aminotransferase normalization and loss of plasma viral RNA, but relapse rates are high, and sustained virological remissions is observed only in 10-25% of the patients....
4 Pages (1000 words) Essay

Hard water in Chemistry

Calculation Below is the initial ionization H3PO4 --------> H+ + H2PO4- K1 = Calculations of relative amounts are obtained through their normalization.... Calcium hydroxide is slowly added drop by drop to the acid, HCL until the solutions starts turning pink.... This shows that the acid is being neutralised, that is, a neutral pH of 7 is being achieved.... By using the pH and all the above pKs of phosphoric acid, the ratios of each of the phosphoric pairs are calculated....
2 Pages (500 words) Assignment

NORMALIZATION AND SQL DDL STATEMENTS

Employee (num,… The ACID model is a theoretical transactional model for database systems that puts forward the four goals (Atomicity, Consistency, Isolation and Durability) achieving which is essential for a database system to become a normalization and SQL DDL ments By: First Last 8th December Database from Module 3 The database before normalization is as follows.... The Need for Database NormalizationDatabase normalization is a set of guidelines that helps in organizing data efficiently which improves the overall performance of a DBMS....
2 Pages (500 words) Essay

New Variant Creutzfeldt-Jacob Disease

PrPsc protein does not appear to have its amino-acid sequence modified although its glycosylation pattern almost definitely differs from PrPc.... … New Variant CJDVariant Creutzfeldt-Jacob Disease (vCJD): An Introduction Variant CJD (vCJD) is a rare, degenerative, fatal brain disorder in humans....
12 Pages (3000 words) Essay

Quality Control, Microarrays Data Calibration and the Quantification of Differential Expression

The results were compared through normalization and random array as well as outlier removal.... normalization is the manipulation of the datasets to have uniformity using many approaches among the box plots and best fit in scatter diagram.... … The paper “Quality Control, Microarrays Data Calibration and the Quantification of Differential Expression” is a persuasive variant lab report on biology....
7 Pages (1750 words) Lab Report

Old and New Wars

With the transformation of the state scheme as a result of globalization and post-modernity, it was unavoidable that war, as a continuance of political affairs, would also transform.... nbsp;This paper "Old and New Wars" looks at how new wars are different from old wars.... hellip; New wars are fundamentally different from old wars in that they are wars of the period of globalization while old wars were wars that prevailed in the 19th and 20th centuries....
8 Pages (2000 words) Literature review
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us