First, I would like to summarize the problems solved by the five normal patterns that need to be analyzed in one sentence:
1nf: attribute atomicity
2nf: partially dependent
3nf: Pass dependency (key code for non-primary attributes)
Bcnf: Pass dependencies (Primary attribute pair candidate keys)
4nf: (the highest level paradigm, which is not often referenced here) D is a set of FD and MVPs established on R, in addition, the left part of X → y of every non-flat method in D is the Super key of R.
The first paradigm is ignored. The fourth paradigm is not commonly used for drawing omitted.
2nf is as follows:
3nf:
Bcnf:
As for 4nf, I am not sure yet. Please advise me. However, in other paradigms, I feel that I can understand myself. If you do not understand me, you can click "Q me" in the upper right corner to discuss it ~
Analysis of paradigm Graphs