Normalization of Database Table

Question 1

It is a process for evaluating and correcting table structures to minimize data redundancies,
thereby reducing the likelihood of data anomalies.

Answer 1

Normalization

Question 2

It produces a lower normal form; that is, a 3NF will be converted to a 2NF through denormalization.

Answer 2

Denormalization

Question 3

It exists when there is a functional dependence in which
the determinant is only part of the primary key

Answer 3

Partial Dependency

Question 4

It exists when there are functional dependencies such that X → Y, Y → Z, and X is the primary key.

Answer 4

Transitive Dependency

Question 5

It derives its name from the fact that a group of multiple
entries of the same type can exist for any single key attribute occurrence.

Answer 5

Repeating Group