数据库设计中ER模型设计的一些基本问题探讨  

Discussion on some basic problems of ER model design in database design

作　　者：牛荣[1] 陈纪龙[1] 杜义君[1] NIU Rong;CHEN Ji-long;DU Yi-jun

机构地区：[1]塔里木大学信息工程学院

出　　处：《信息技术与信息化》2019年第7期189-192,共4页Information Technology and Informatization

基　　金：塔里木大学“课程思政”示范团队项目《数据库原理》

摘　　要：数据库设计中的概念结构设计阶段是一个复杂过程,学生在设计时往往不能很快的上手,或者设计出来的ER图不合理或错误。本文针对学生在设计时易出现的问题和难点进行分析,通过一个设计好的ER图剖析其中存在的问题和错误。进而进一步论述了属性和实体的判断方法,属性间联系的判断和元数的确定方法,以及聚集的使用。通过论述为学生在数据库概念结构设计时提供可操作性强的方法和指导。The conceptual structure design stage in database design is a complex process. Students often fail to get started quickly when designing, or the ER diagram is unreasonable or wrong. In this paper, the problems and difficulties that students are easy to appear in the design are analyzed, and the problems and mistakes are analyzed through a well designed ER diagram. Then it further discusses the judgment method of attribute and entity, the judgment of relation between attributes and the method of determining the number of elements, and the use of aggregation. This paper provides a strong maneuverability method and guidance for the students to design the conceptual structure of the database.

关 键 词：概念结构设计 ER模型 聚集 

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