Database design can be divided into several stages

This article mainly introduces the database design can be divided into several stages, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

According to the standard design method, the database design is divided into six stages: 1, requirement analysis; 2, conceptual structure design; 3, logical structure design; 4, database physical design; 5, database implementation; 6, database operation and maintenance.

According to the standard design method, a complete database design is generally divided into the following six stages:

1. Demand analysis

Analyze user needs, including data, functional, and performance requirements.

2. Conceptual structure design.

Mainly use Emurr model for design, including drawing Emurr diagram.

3. Logical structure design

By transforming the Emurr diagram into a table, the transformation from the Emurr model to the relational model is realized and the relationship is normalized.

4. Physical design of database

The main purpose is to choose the appropriate storage structure and storage path for the designed database.

5. Implementation of database

This includes programming, testing, and commissioning.

6. Database operation and maintenance

Operation of the system and daily maintenance of the database.

Thank you for reading this article carefully. I hope the article "Database Design can be divided into several stages" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!