Explain ACID properties and Normalization

Question

Accepted Answer

ACID properties ensure database transactions are reliable. Normalization reduces data redundancy.

ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single unit of work.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent transactions do not interfere with each other.
Durability ensures that once a transaction is committed, it will remain committed even in the face of power loss or system failure.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
For example, a customer table may be normalized into a customer table and an orders table, with a foreign key relationship between them.

Top GlobalLogic Associate Consultant Engineering interview questions & answers