Data Normalization

Loss of related dataset when some other dataset is deleted.

What is a primary key in a relational database?

• A unique identifier for a record in a table

• A foreign key in another table

• A method to sort records in a table

What is data normalization?

• The process of converting data into a different format for storage

• The process of transforming data into a common format to eliminate redundancy and improve data integrity

• The process of organizing data into a database

Select the following that is an advantage of data normalization

• Decreased database performance

• Improved data integrity

• Increased data redundancy

In which normal form is each non-key attribute functionally dependent on the entire primary key?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Which normal form eliminates transitive dependencies?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Which of the following is not a common method of data normalization?

• Removing duplicate records

• Splitting tables

• Creating new tables with foreign keys

Which normal form is often considered sufficient for most database design purposes?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Each column should contain single values.

• True

• False

A column can contain values that are not of the same type.

• True

• False