Database design Process

Get started with user needs

The main function diagram of the software design:

Because users are divided into general users, operators, administrators. The first column is the function of the administrator, the second column is the function of the operator, and the third column is the function of the general user.

Design of E-r diagram

、

Conversion of E-r diagram to relational mode

E-r diagram design is not said to be static, because no one can guarantee that the E-r diagram and the actual need to use the table, the data is exactly the same, so the e-r diagram is constantly changing.

e-r-diagram is only a design of the relationship between the model of the intermediary, it is only to make it easier for us to design a relational table.

Database design Process