First normal form:
There should be no repeated fields, and no arrays. All the entries in an attribute should be of the same kind. Break out any repetitions, give everything a key
2nd Normal form:
You should remove all functional dependencies: (Sub Themes, groups of attributes that relate to each other but not to the topic (key) of the entity
3rd Normal form
Is about removing transient dependencies--attributes that modify or describe another attribute and not the key
Here is the student entity not normalized
Here is the student ERD after normalization
No comments:
Post a Comment