The design of the logical structure of the <br>database The design of the logical structure of the database can be divided into three stages, namely: user needs, the establishment of the ER model and the design of the database model. <br>In the first stage of the database logic design, user needs will be collected or analyzed in the following four steps: analyzing user activities, determining the system scope, and analyzing the impact of user activities on data. The second stage of establishing the logical design of the ER model is divided into two steps. First, part of the ER model design should be carried out, and then the overall ER model design should be carried out. The third stage of logic design is implemented in two steps in the database schema design stage. The first step is the preliminary design, which converts the ER diagram into a relational model, and the second step is to optimize the design to adjust and improve the model.
正在翻译中..