Database Normalization

Question 1

Define Normalization

Answer 1

It is a process used to organize databases into tables and columns to reduce redundancy and improve data integrity

Question 2

Of the 3 most commonly applied normal forms (NFs), which of them applies to tables that contain composite primary keys

Answer 2

2NF

Question 3

This NF ensures all columns have atomic values

Answer 3

1NF

Question 4

There are no transitive dependencies in this NF

Answer 4

3NF

Question 5

A __________ dependency is when a non-key attribute depends on another non-key attribute

Answer 5

Transitive

Question 6

All non-key attributes are fully dependent on the entire primary key (PK)

Answer 6

2NF

Question 7

In this form, each row in the table is uniquely identified by a PK

Answer 7

1NF