电子测试
電子測試
전자측시
ELECTRONIC TEST
2014年
16期
11-12,5
,共3页
音乐器材%管理系统%账务处理%数据完整性设计
音樂器材%管理繫統%賬務處理%數據完整性設計
음악기재%관리계통%장무처리%수거완정성설계
music equipment%management system%accounting treatment%data integrity design
本文以音乐器材管理账务处理系统数据库设计为基础，进行数据完整性设计。实体完整性通过主关键字实现，设计了三个表的主关键字，并说明了创建主关键字的语法；参照完整性通过外关键字实现，设计了两个一对多关系的外关键字，并说明了创建外关键字的语法；用户自定义完整性通过为有关字段设计相应的约束实现。
本文以音樂器材管理賬務處理繫統數據庫設計為基礎，進行數據完整性設計。實體完整性通過主關鍵字實現，設計瞭三箇錶的主關鍵字，併說明瞭創建主關鍵字的語法；參照完整性通過外關鍵字實現，設計瞭兩箇一對多關繫的外關鍵字，併說明瞭創建外關鍵字的語法；用戶自定義完整性通過為有關字段設計相應的約束實現。
본문이음악기재관리장무처리계통수거고설계위기출，진행수거완정성설계。실체완정성통과주관건자실현，설계료삼개표적주관건자，병설명료창건주관건자적어법；삼조완정성통과외관건자실현，설계료량개일대다관계적외관건자，병설명료창건외관건자적어법；용호자정의완정성통과위유관자단설계상응적약속실현。
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.
