高校体育类专业招生管理系统数据库设计  

Database design of enrolling management system of college sports class majors

作　　者：张颖[1] 

机构地区：[1]渤海大学教育与体育学院,辽宁锦州121013

出　　处：《信息技术》2014年第6期42-45,共4页Information Technology

基　　金：国家自然科学基金(31100760)

摘　　要：目前我国高校招生普遍使用计算机系统,数据库设计是开发系统的核心工作。针对体育类招生考试需要处理大量数据以及软件开发难等问题,以体育类专业招生需求分析为基础,运用新奥尔良法进行数据库设计。首先,进行概念结构设计,设计结果用E-R模型表示;然后,进行逻辑结构设计,按照设计原则将E-R模型转换为关系结构;最后,进行完整性设计,包括实体完整性设计、参照完整性设计和用定自定义完整性设计。设计的数据库具有完整性好、安全性高、操作速度快等优点,为开发性能优良的体育类招生管理系统奠定了基础。At present, Chinese university enrollment widespread use computer systems, and database design is the core of development systems. For the sports class enrollment needs to handle large amounts of data and software development difficult issues, this paper based on the analysis of sports class enrollment requirements, uses New Orleans method for database design. First, conceptual structure design, represents the design results as E-R model. Second, logical structure design, according to the design principles transform E-R model into a relational structure. Finally, integrity design, includes entity integrity design, referential integrity design and user-defined integrity design. This database has the advantages of good integrity, high safety, fast operation speed, it is laid a foundation for sports class enrollment to develop an excellent performance management system.

关 键 词：体育类专业 招生管理系统 数据库设计 概念结构 逻辑结构 完整性 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]