Home > Database > SQL > body text

What are the stages of database design?

王林
Release: 2020-07-16 13:38:51
Original
36865 people have browsed it

According to the standardized design method, database design is divided into six stages: 1. Requirements analysis; 2. Conceptual structure design; 3. Logical structure design; 4. Database physical design; 5. Database implementation. ; 6. Database operation and maintenance.

What are the stages of database design?

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

(Recommended study: mysql tutorial)

1. Requirements analysis

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

2. Conceptual structure design

Mainly uses the E-R model for design, including drawing E-R diagrams.

3. Logical structure design

By converting the E-R diagram into a table, the conversion from the E-R model to the relational model is realized and the relationship is standardized.

4. Database physical design

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

5. Database implementation

includes programming, testing and trial operation.

6. Database operation and maintenance

System operation and daily maintenance of the database.

The above is the detailed content of What are the stages of database design?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!