| 基于教学管理系统的数据库及其完整性的设计与实现 |
| |
| 引用本文： | 吴莉霞.基于教学管理系统的数据库及其完整性的设计与实现[J].宝鸡文理学院学报(自然科学版),2013(3):61-64. |
| |
| 作者姓名： | 吴莉霞 |
| |
| 作者单位： | 宝鸡文理学院计算机科学系,陕西宝鸡721016 |
| |
| 基金项目： | 宝鸡文理学院重点科研项目（ZK10116） |
| |
| 摘 要： | 目的为了防止教学管理系统数据库中出现不正确和不相容的数据，给出了该系统数据库及其完整性约束的具体设计与实现方法。方法通过数据库规范化设计方法对教学管理系统数据库建模，给出了教学管理系统从数据库需求分析到概要设计过程中的E—R图，再到逻辑设计的关系模式。结果给出了数据库完整性在教学管理数据库设计中的实现方法。结论通过对教学管理系统数据库完整性的设计与实现，提高了教学管理应用系统的开发与使用性能。
|
| 关 键 词： | 数据库 E—R图 关系模式 规范化理论 数据库完整性 |
Design and implementation of database and its integrity in teaching management system |
| |
| WU Li-xia.Design and implementation of database and its integrity in teaching management system[J].Journal of Baoji College of Arts and Science(Natural Science Edition),2013(3):61-64. |
| |
| Authors: | WU Li-xia |
| |
| Institution: | WU Li-xia (Dept. Computer Sci. , Baoji University of Arts and Sciences, Baoji 721016, Shaanxi, China) |
| |
| Abstract: | Objective--To give a specific design and implementation method of database and its in- tegrity constraints in teaching management system so that the appearance of incorrectness and incon- sistent data in teaching management system can be avoided. Methods--The database model of teaching management system is built with appropriate normal design method, offering an E-R diagram from da- tabase requirement analysis to preliminary design and the relational schemas of logic design. Results-- The design and implementation method of database integrity in teaching management system is ex- pounded. Conclusion--The development and usability of the teaching management system are im- proved by the design and implementation of database integrity. |
| |
| Keywords: | database E-R diagram relational schema normalization theory database integrity |
| 本文献已被 维普 等数据库收录！ |
