Book chapter
Binary representation of ternary relationships in ER conceptual modeling
OOER '95: Object-Oriented and Entity-Relationship Modeling
10 Jun 2005
Abstract
Our paper seeks to provide an analysis of ternary relationship logic with an objective of identifying whether they can be decomposed given only the constructs and constraints provided during conceptual entity relationship (ER) modeling.
Our paper investigates which ternary relationship cardinality combinations can be losslessly decomposed, which combinations preserve functional dependencies, and whether the logic involved in these processes is sufficient to provide a model which is rigorous at the physical or practical level. We show that if ternary relationships can be explicitly constrained by binary cardinalities, some ternary/binary cardinality combinations have legitimate equivalencies in a binary decomposed form, but that certain other combinations cannot be decomposed without creating additional implementation concerns.
Metrics
11 Record Views
4 citations in Scopus
Details
- Title
- Binary representation of ternary relationships in ER conceptual modeling
- Creators
- Trevor H. Jones - Duquesne UniversityIl-Yeol Song - Drexel University
- Publication Details
- OOER '95: Object-Oriented and Entity-Relationship Modeling
- 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-84947722271
- Other Identifier
- 991019184177804721