[database] knowledge and skills at the end of the term ----- Chapter 9 database design

Chapter nine Database design

1、 What are the stages of database design , What documents are generated ？

1） Demand analysis --- The data dictionary

2） Conceptual structural design ---E-R chart ,UML

3） Logical structure design --- Relationship model

4） Physical structure design

5） Database implementation

6） Database operation and maintenance

2、 The main tasks of each stage ？

The main tasks corresponding to the six stages

1） Investigate and analyze user activity , Collect and analyze demand data and prepare system analysis report

2） The user requirements obtained from requirement analysis are abstracted into information structure E-R chart

3） take E-R The diagram is transformed into a logical structure （ Relationship model ）

4） Choose a storage structure and storage method for the logical data model

5） Use DDL Define the data structure , Data loading , Programming and debugging applications , Test run the database

6） Database dump and recovery , Safety integrity control , Performance improvements , Reconstruction of database

3、 Give requirements , Be able to draw E-R chart （ To be able to E-R Graph to relational pattern , The connection between entities ,1:1, 1：n, m：n,, meaning , drawing ）

  Reference resources ： database -E-R Picture exercise _Mark7758 The blog of -CSDN Blog _ There are two entities: athletes and competition events