课表编排系统中数据库的设计与实现

Design and Implementation of the Database in Timetable Planning System

论述了课表编排系统数据库的概念模型、逻辑模型以及物理模型的设计和规范化设计。为防止不符合语义的错误数据的输入输出,数据库设计中采用了主键约束、唯一性约束、外键约束、缺省、规则和触发器等技术来保护数据库的完整性。

Discusses the designs of concept models,logic models,physical models and standardization of the database in timetable planning system. In order to hold back the input or output of misdata which is unfit for the semantics,the database design uses the primary key constraint,the uniqueness constraint,the foreign key constraint,defaults,rules and triggers to keep the integrality of database.