Normalization

Question 1

data cleaning

Answer 1

fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset

Question 2

First Normal Form

Answer 2

Table format, no repeating groups, and PK
identified

Question 3

Second Normal Form

Answer 3

1NF and no partial dependencies

Question 4

Third Normal Form

Answer 4

2NF and no transitive dependencies

Question 5

Boyce-Codd normal form (BCNF)

Answer 5

every determinant is a candidate key (special case of 3NF)

Question 6

Fourth normal form (4NF)

Answer 6

3NF and no independent multivalued
dependencies

Question 7

What is normalization?

Answer 7

process for evaluating and decomposing each table (relation) into
multiple tables (relations) to minimize data redundancies

Question 8

Why is normalization required?

Answer 8

when we build the database, we have raw data that’s redundant, inconsistent, and lack data integrity.

ex: spreadsheets don’t enforce datatypes or ranges

Question 9

each table should consists of what 2 things?

Answer 9

primary key, set of mutually independent attributes

Question 10

safety levels checks through normal form

(least important –> most important)

Answer 10

!NF –> 2NF –> 3NF –> 4NF –> 5NF

Question 11

Fifth Normal Form (5NF) and domain-key normal form are defined but not . . .

Answer 11

generally enforced