Database Normalization

Today I will be going over Database Normalization and how that will work for the database I have beastmodecap_covid.

Here is an example of what one of the three things that I will be talking about. This one in particular is failing the third part of the first database normalization category.

I will be talking about the first two database normalization models. There is a total of five and the sixth is not standardized.

All of the rules for the first database normalization goes as such:

1. Each primary key needs to be unique.

2. Each table cell should contain a single value.

3. There can be no duplicating groups.

The second database normalization needs to be the first database normalization.
The two rules for the second database normalization are as follows:

1. Be in the first database normalization

2. Single Column Primary Key

Here is an example of the second database normalization:

This fails because of the JobRisk is not related to the behaviors you have in the day.

Here is the youtube video of me talking about database normalization: https://www.youtube.com/watch?v=AzDduP1GZhk&ab_channel=BeastMode