FCPC-DBMS-MidtermExam

Normalization is the process of organizing data into tables to reduce data redundancy and dependency.

• TRUE

• FALSE

Normalization always results in a higher level of data redundancy.

• TRUE

• FALSE

Normalization is a one-time process and does not need to be revisited.

• TRUE

• FALSE

Denormalization is the process of breaking tables down into smaller pieces.

• TRUE

• FALSE

A database can be over-normalized, resulting in poor performance.

• TRUE

• FALSE

A well-designed database should have no redundant data.

• TRUE

• FALSE

Third normal form (3NF) is always better than second normal form (2NF).

• TRUE

• FALSE

Normalization always improves data integrity.

• TRUE

• FALSE

The process of normalization is purely technical and does not require any understanding of the business requirements.

• TRUE

• FALSE

Data modeling is the process of creating a physical representation of a database.

• TRUE

• FALSE