音乐器材管理账务处理系统数据完整性设计

Data integrity design on accounting treatment system for music equipment management

本文以音乐器材管理账务处理系统数据库设计为基础,进行数据完整性设计。实体完整性通过主关键字实现,设计了三个表的主关键字,并说明了创建主关键字的语法;参照完整性通过外关键字实现,设计了两个一对多关系的外关键字,并说明了创建外关键字的语法;用户自定义完整性通过为有关字段设计相应的约束实现。

This paper conducted data integrity design based on the database design on accounting treatment system for music equipment management.Entity integrity was achieved by the primary key,and it designed primary key of three tables and described the syntax when created primary key;referential integrity was achieved by foreign key,and it designed foreign key which has two one-to-many relationships and explained the syntax when created foreign key;user-defined integrity was achieved by designing the corresponding constraint for relevant fields.