教务管理信息系统的数据库建模

数据库建模是数据库应用系统开发的关键步骤。在传统的结构化系统设计中，将需求分析阶段得到的ER图转化为关系数据库模型，而ER图仅仅着眼于数据。为了提高开发效率。采用面向对象的系统分析和设计方法，用系统分析阶段所获得的UML类图为基础进行数据库的逻辑结构设计，把类图转化为关系数据库模型。UML类图不但对数据建模，而且能对行为建模，这些行为在物理数据库中被设计成触发器和存储过程。在此以已开发的教务管理信息系统的数据库建模为例，讨论基于UML类图的数据库建模的方法与过程，该系统主要实现学生学籍管理和成绩管理。

Database modeling of information system for educational administration management

In order to improve the developing efficiency,OOA and OOD were adopted,the logic structural design of the database was conducted based on UML class diagram obtained in the stage of system analysis,and the class diagram was converted to the relation database model during oriented object design.The class diagram is focus on data and behavior modeling.The behavior can be designed as the trigger and stored procedure in physical database.Taking the designed database modeling of educational administration management information system as an example,the method and process of database modeling based on UML class diagram are discussed in detail.