文章基本信息

标题：AVOIDANCE OF CYCLICAL REFERENCE OF FOREIGN KEYS IN DATA MODELING USING THE ENTITY-RELATIONSHIP MODEL
本地全文：下载
作者：Ben Kim
期刊名称：Issues in Information Systems
印刷版ISSN：1529-7314
出版年度：2006
卷号：7
期号：2
页码：263-268
出版社：International Association for Computer Information Systems
摘要：The entity-relationship (ER) model is clearly established as a conceptual model of choice when building relational database systems. Once the ER model is built, it can be mapped algorithmically to the relational model and consequently to the data definition language (DDL) of SQL. Algorithmic mapping of the ER model to the relational model can produce foreign keys referencing each other’s tables cyclically. This cyclical reference of foreign keys generates irresolvable deadlocks when enforcing the referential integrity rule using the cascading option. However, it is not obvious for database designers while building an ER model. In this article, we provide a set of rules of ER modeling for avoiding cyclical references of foreign keys.
关键词：Database Design; Cyclical Reference;Foreign Keys; Entity-Relationship Model; Relational;Model