Wednesday, October 3, 2018

Normalization. Afternoon

First Normal Form

all the data in an attribute must be of the same kind (logical, data type)

No lists or arrays

Track1, track2, track3. . .13

"track1,track2,track3..."

Second Normal Form

Assumes 1NF

Remove Structural dependencies, subsets, Groups of attributes that refer to each other but not to the topic (key) of the entity

Third Normal Form

Assumes 2NF

Remove transistive dependencies

One attribute that refers to another attribute

The Gist

Every Entity should be about one thing

Every attribute in the entity should describe that entity

Here is our final ERD

No comments:

Post a Comment