Focus on the same theme
Ensure that relevant data is stored centrally for easy search and management.
Eliminate redundancy
Improve database performance and ensure data accuracy.
Follow the third paradigm
Standardize the relationship and reduce abnormal problems such as data redundancy.
A clear relationship
In a many-to-many relationship, it needs to be transformed into a one-to-many relationship.
Dynamic adaptability
The design takes into account the future demand changes, making the table structure more flexible.
Deep understanding of requirements
Define the user's data and processing requirements, as well as security and integrity requirements.
Conceptual model design
Use data abstraction to create system conceptual models, such as E-R model.
Logical structure planning
Define the mode and external mode of the system, especially the basic tables and views.
Physical structure optimization
Design storage structures and access methods, such as creating indexes.
System implementation and testing
Organize data storage, write programs, and try out.
Long term maintenance
During the operation of the system, the maintenance work continues.