摘要
E-R模型(EntityRelationshipDiagram),即实体-联系模型,也称E-R图,是数据库开发过程中继需求分析之后的首要步骤。E-R模型的合理性直接影响数据库结构的合理性,进而影响整个系统的性能。因此如何科学合理的定义实体和属性,确定实体和实体之间的联系,舍去或保留哪些联系都是非常关键的。本研究基于零售业销售的特点,绘制了两种E-R模型,通过对比选出了一个一般性模型,该模型可以用于小型数据库系统的开发,也可用于理论研究。
E-R model(Entity Relation Diagram),also known as E-R diagram,is the first step after requirement analysis in the process of database development.The rationality of E-R model directly affects the rationality of database structure,and then affects the performance of the whole system.Therefore,how to define entities and attributes scientifically and reasonably,how to determine the relationship between entities,and how to choose the relationship are very important.Based on the characteristics of the retail sales,this paper draws two E-R models,and selects a general model by comparison.The model can be used in the development of small-scale database systems,but also can be used in theoretical research.
作者
王伟丽
Wang Weili(Tianjin University Renai College, Tianjin 301636, China)
出处
《信息与电脑》
2018年第23期91-92,共2页
Information & Computer
