Brief introduction of the paradigm and application of database design

The General build table satisfies the first 3 paradigms and is sufficient for the optimization of the table structure, which avoids the complexity of the application and avoids the inefficiency of the system due to the large SQL statement.

The first paradigm: if each property of the relationship pattern R is non-decomposed and has a primary key, it is the first normal form;

Second paradigm: If R belongs to the first paradigm, and all non-primary key attributes are completely dependent on the primary key attribute, the second normal form is satisfied.

The third paradigm: if R belongs to the second paradigm, and none of the non-primary key attributes is a transfer function that relies on the candidate primary key attribute, the third paradigm is satisfied.

In practical use, the inverse paradigm can be released on demand.

Brief introduction of the paradigm and application of database design