Chapter 9 - Databases - Specifically Normalization

Question 1

What is normalization?

Answer 1

The process of separating your data into tables and creating primary keys.

Question 2

What is the main goal of normalization?

Answer 2

To make sure each piece of information appears in the database only once, to increase efficiency.

Question 3

what are the three database rules to satisfy the “First Normal Form”?

Answer 3

There shuld be no repeating columns containing the same kind of data.

All columns should contain a single value.

There should be a primary key to uniquely identify each row.

Question 4

When should you not use normalization?

Answer 4

On high traffic sites.

normalization requires spreading data across multiple tables, and this means making multiple calls to MySQL for each query. On a very popular site, if you have a normalized tables, your database access will slow down considerable once you get above a few dozen concurrent users.

Question 5

When should you not use normalization?

Answer 5

On high traffic sites.

normalization requires spreading data across multiple tables, and this means making multiple calls to MySQL for each query. On a very popular site, if you have a normalized tables, your database access will slow down considerable once you get above a few dozen concurrent users.