You need to ensure the data integrity of a database by resolving insertion, update, and
deletion anomalies.
Which term is used to describe this process in relational database design?
A.
Isolation
B.
Normalization
C.
Integration
D.
Resolution
Explanation:
Database normalization is the process of organizing the fields and tables of a relational
database to minimize redundancy. Normalization usually involves dividing large tables into
smaller (and less redundant) tables and defining relationships between them. The objective
is to isolate data so that additions, deletions, and modifications of a field can be made in just
one table and then propagated through the rest of the database using the defined
relationships.