MySQL Learning notes--three paradigms to be met for building tables

First paradigm:

The atomicity of the field, that is, all columns in the table are no longer divided.

For example, a table has the origin of this column, but the place of origin can be divided into provinces and municipalities, so do not meet the first paradigm.

Second paradigm:

On the basis of satisfying the first paradigm, it is required that each record must be uniquely identified, while non-primary key fields in the table cannot have a partial function dependency on the primary key (mainly for the composite primary key), that is, each column in the table is related to all fields in the primary key, not to some fields in the primary key

The third paradigm:

There can be no transitive dependency, that is, each column in the table is related to the primary key, not the indirect correlation

MySQL Learning notes--three paradigms to be met for building tables