mysql - 在数据库设计过程中ER模型起到什么作用？

Question

在数据库设计之前往往会先提到ER模型，那ER模型在数据库设计过程中起到什么作用呢？

Answer 1

The ER model is a bridge between the real world and the program data world. The business relationships of the program can be clarified through the ER diagram. In engineering, only when the business relationships are clarified can the database be designed and the corresponding Coding work. In fact, in a large project, designing the database and clarifying business relationships may even take longer than the actual coding. . .

Answer 2

As I understand it, the ER model helps you map the data content of the real world into a model, and then transform the model into a specific database design. I understand it as a tool, because it suddenly switches from real data entities to database design. You will have no clue, and ER helps you design in an organized and systematic way