Normalization: Morning

Here are the rules for the first three normal forms

First Normal Form

Everything in a column must be of the same type (logically, datatype)

No Lists

No arrays

if lists or arrays break into a new entity

Second Normal Form

Get rid of subsets, groups of attributes that depend on each other rather than the topic (key) of the Entity (the group of advisor attributes that don't relate directly to student.)

Structural dependencies.

Third normal forms

- remove transitive dependency. One attribute that relates to something other than the topic of the entity.

The gist

Every column should have values of the same type

No arrays or lists (any plural values should be broken into their own entity)

An entity should only be about one thing

Anything that relates to something other than the topic of entity should be broken out into a new entity

Here is the student Entity as we started

Here is the diagram after normalizing