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