Shulou(Shulou.com)06/01 Report--

What are the basic principles of database design? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Basic principles of database design:

(1) Storage the data with the same topic in a data table, "one table for 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

The answers to the questions about the basic principles of database design are shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.