What are the main steps of database design

This article is about what the main steps of database design are. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The basic principles of database design are: 1, to store the data with the same topic in a data table; 2, to eliminate redundancy as far as possible and improve the speed of accessing the database; 3. When designing the structure of the data table, the dynamic adaptability of the table structure should be considered.

Basic principles of database design:

(1) the data with the same topic is stored in a data table, "one table and one use".

(2) eliminate redundancy as far as possible and improve the speed of accessing database.

(3) the database design is generally required to reach the third normal form, many-to-many, which eliminates data redundancy, modification exception, insertion exception and deletion exception to the maximum, and basically meets the requirements of relationship standardization.

(4) in the relational database, the relationship between the data tables can only be one-to-one and one-to-many. A many-to-many relationship must be transformed into an one-to-many relationship.

(5) when designing the data table structure, the dynamic adaptability of the table structure should be considered.

The main steps of database design:

1. Requirements analysis: understand users' data requirements, processing requirements, security and integrity requirements

2. Conceptual design: through data abstraction, the conceptual model of the system is designed, which is generally called Emurr model.

3. Logical structure design: design the schema and external schema of the system, mainly the basic tables and views for the relational model.

4. Physical structure design: design the storage structure and access methods of data, such as index design.

5. System implementation: organizing data storage, compiling application programs, and trial operation

6. Operation and maintenance: the system is put into operation and long-term maintenance work.

Thank you for reading! On the main steps of database design is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.