文章基本信息

标题：Design Methodology for Relational Databases : Issues Related to Ternary Relationships in Entitiy-Relationship Model and Higher Normal Forms
本地全文：下载
作者：Vimala ; H Khanna Nehemiah ; R S Bhuvaneswaran 等
期刊名称：International Journal of Database Management Systems
印刷版ISSN：0975-5985
电子版ISSN：0975-5705
出版年度：2013
卷号：5
期号：3
出版社：Academy & Industry Research Collaboration Center (AIRCC)
摘要：Entity-Relationship (ER) modeling plays a major role in relational database design. The data requirements are conceptualized using an ER model and then transformed to relations. If the requirements are well understood by the designer and then if the ER model is modeled and transformed to relations, the resultant relations will be normalized. However the choice of modeling relationships between entities with appropriate degree and cardinality ratio has a very severe impact on database design. In this paper, we focus on the issues related to modeling binary relationships, ternary relationships, decomposing ternary relationships to binary equivalents and transforming the same to relations. The impact of applying higher normal forms to relations with composite keys is analyzed. We have also proposed a methodology which database designers must follow during each phase of database design.
关键词：Entity-Relationship Model; Database Design; Binary Relationship; Ternary Relationship; Normalization;Functional Dependencies.