First in a sentence to summarize the analysis of the 5 paradigm to solve the problem:
1NF: Atomicity of properties
2NF: Partially dependent
3NF: Transitive dependency (non-primary attribute to key code)
BCNF: Transitive dependency (primary attribute pair candidate key)
4NF: (the highest-level paradigm, not often used here for reference definitions) d is the set of FD and MVD set on R, and the left x of each non-x→→y in D is a super-key of R
In the first paradigm, the drawing is omitted. The IV paradigm does not often use drawing ellipsis.
2NF For example the following:
3NF:
BCNF:
As for 4NF, I am not too clear now, please the hero to enlighten. But other paradigms, I feel self-understanding can also, if you do not know a friend can click on the top right corner of the "Q I" together to explore ~
An analysis of the pattern pattern