Seatwork Fundamentals of Database Normalization

______ is the process of organizing the data in the database

• Normalization

• First normal form

• Second normal form

• Normalization

The normal form is not used to reduce redundancy from the database table.

• TRUE

• FALSE

The main reason for normalizing the relations is removing these anomalies. Failure to eliminate anomalies leads to data redundancy and can cause data integrity and other problems as the database grows.

• True

• False

Refers to when one cannot _____ a new tuple into a relationship due to lack of data.

• Updatation Anomaly

• Insertion Anomaly

• Deletion Anomaly

Refers to the situation where the ______ of data results in the unintended loss of some other important data.

• Updatation Anomaly

• Insertion Anomaly

• Deletion Anomaly

When an _____ of a single data value requires multiple rows of data to be updated.

• Updatation Anomaly

• Insertion Anomaly

• Deletion Anomaly

• Updation Anomaly

There are only Single Valued Attributes.

• First normal form

• Second normal form

• BOYCE - CODD normal form

In First normal form Attribute Domain does change.

• TRUE

• FALSE

It is based on full functional dependency.

• First normal form

• Third normal form

• Second normal form

• BOYCE - CODD normal form

This normalization form consist of composite key.

• First normal form

• Second normal form

• Third normal form

• BOYCE - CODD normal form