Home / JDBC / ACID Properties and Normalization

ACID Properties and Normalization

ACID properties are one of the important concepts for databases. ACID stands for Atomicity, Consistency, Isolation, and Durability. These properties of a DBMS allow safe sharing of data. Without these properties, the inaccuracy in the data will be huge. With the help of the ACID properties, the accuracy can be maintained.

Normalization is a design technique which helps the to design the relational databases. Normalization is essentially a two-step process that puts data into tabular form by removing redundant data from the relational tables. A basic goal of normalization is to create a set of relational tables that are free of redundant data and the data should be consistent. Normalization has been divided into following forms.

1. First Normal Form: A relational table, by definition, are in first normal form. All values of the columns are atomic. It means that it contains no repeating values.

2). A relational table is in second normal form if it is in 1NF and every non- key column is fully dependent upon the primary key.

3). A relational table is in third normal form (3NF) if it is already in 2NF and every non- key column is non-transitively dependent upon its primary key. The advantage of having a table in 3NF is that it eliminates redundant data which in turn saves space and reduces manipulation anomalies.