Book chapter
Analysis of binary relationships within ternary relationships in ER modeling
Entity-Relationship Approach — ER '93, pp 271-282
18 Jun 2005
Abstract
In this paper, we discuss which binary relationship cardinalities are permitted within ternary relationships, during ER modeling. We develop an implicit Binary Cardinality (IBC) rule, which states that, in any ternary relationship, the cardinality of any binary relationship embedded in the ternary, is many-to-many when there are no explicit constraints on the data instances. We then present an Explicit Binary Permission (EBP) rule, which explains and enumerates all permitted binary relationships for various cardinalities of ternary relationships. Finally we present an Implicit Binary Override (IBO) rule, which states that the implicit binary cardinalities can be constrained in a ternary relationship by explicit constraints imposed by a binary relationship. We also detail how the cardinalities within the ternary are altered as a single binary, and then multiple binary relationships are imposed.
Metrics
8 Record Views
3 citations in Scopus
Details
- Title
- Analysis of binary relationships within ternary relationships in ER modeling
- Creators
- Il-Yeol Song - Drexel UniversityTrevor H. Jones - Drexel University
- Publication Details
- Entity-Relationship Approach — ER '93, pp 271-282
- Series
- Lecture Notes in Computer Science
- Publisher
- Springer Berlin Heidelberg; Berlin, Heidelberg
- Resource Type
- Book chapter
- Language
- English
- Academic Unit
- Information Science
- Scopus ID
- 2-s2.0-0346435565
- Other Identifier
- 991019183961804721