What does database design mainly include?

The main contents of database design include: 1. Requirements analysis; 2. Conceptual structure design; 3. Logical structure design; 4. Physical structure design; 5. Database implementation and database operation and maintenance.

【Video tutorial recommendation: MySQL tutorial】

Main content of database design

1. Requirements analysis:

Investigate and analyze the user’s business activities and data usage, and clarify the type, scope, and The quantity and their communication in business activities determine the user's requirements for the use of the database system and various constraints, etc., forming a user requirements specification.

Requirements analysis is based on user surveys and analysis to gradually clarify user requirements for the system, including data requirements, business processing requirements surrounding these data, security and integrity requirements.

2. Conceptual structure design:

Describe the real world (which may be a factory, a shopping mall or a school, etc.) that the user needs, through data abstraction. Synthesis, induction and abstraction, establishing abstract conceptual data models, generally E-R models.

This conceptual model should reflect the information structure of various departments in the real world, the flow of information, the mutual constraints between information, and the requirements of each department for information storage, query and processing.

3. Logical structure design:

Convert the conceptual structure into a data model (such as a relational model) supported by a certain DBMS, and optimize it.

4. Physical structure design:

Design the storage structure and access methods of data, such as index design; convert the conceptual structure into one supported by a certain DBMS Data model (e.g. relational model) and optimize it.

5. Database implementation:

Use the data language (such as SQL) and its host language (such as C) provided by the DBMS, based on the logical design and physical design As a result, the database is established, the application program is compiled and debugged, the data is organized into the database, the application program is compiled, and the trial run is carried out.

6. Database operation and maintenance:

The database application system can be put into formal operation after trial operation. During the operation of the database system, long-term maintenance work is required, and it must be continuously evaluated, adjusted and modified.

Note: The design of a complete database application system cannot be accomplished overnight. It often requires repeated repetition of the above six stages.

The above is the entire content of this article, I hope it will be helpful to everyone's study. For more exciting content, you can pay attention to the relevant tutorial columns of the PHP Chinese website! ! !

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