Trident University
Anuj Kainth
Module 4 Case
CSC 316 – Database Systems I
Professor: Michael J. Pelosi
2 March 2014
Acid and Normalization
Normalizing the Database
Simply put, normalization is a formal process for determining which fields belong in which tables in a relational database. Normalization ensures that you get the benefits relational databases offer (Beckett, 1997). Normalizing the tables can be done by eliminating repeating groups, identifying the primary key and identifying all the dependencies. Normalizing the PC store tables required a bit of work. In my tables I identified that I had a dependency in the employee table for jobs. I then created a new job table to normalize the database. This should increase the efficiency of the database by eliminating the redundancies.
I normalized the tables by using the normalization stages. In the first Normal Form I ensured there were no null values, eliminated repeating groups by creating the job tables and identified all the dependencies. The second normal form included another stage which was to identify any partial dependencies. Once I completed this I found that my tables were already in compliance with third normal form standards as all the transitive dependencies now had their own tables.
ACID
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive to achieve: atomicity, consistency, isolation and durability. No database that fails to meet any of these four goals can be considered reliable (Chapple, 2014). Atomicity is an all or none proposition that ensures the integrity of transactions. Consistency ensures that a transaction does not leave the database incomplete. Isolation keeps transactions separated until they are complete and durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination. These rules ensure the database is functional and are very important to developers.
SQL Statements
Normalization/Lessons Learned Normalization is necessary to reduce data redundancies, errors and overall
