Improving database design through the analysis of relationships
Authors:
Open Access
- 1 December 1999
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 24 (4) , 453-486
Abstract
Much of the work on conceptual modeling involves the use of an entity-relationship model in which binary relationships appear as associations between two entities. Relationships involving more than two entities are considered rare and, therefore, have not received adequate attention. This research provides a general framework for the analysis of relationships in which binary relationships simply become a special case. The framework helps a designer to identify ternary and other higher-degree relationships that are commonly represented, often inappropriately, as either entities or binary relationships. Generalized rules are also provided for representing higher-degree relationships in the relational model. This uniform treatment of relationships should significantly ease the burden on a designer by enabling him or her to extract more information from a real-world situation and represent it properly in a conceptual design.Keywords
This publication has 22 references indexed in Scilit:
- Expressing casual relationships in conceptual database schemasJournal of Systems and Software, 1999
- Database design with common sense business reasoning and learningACM Transactions on Database Systems, 1997
- A conceptual database design approach based on rules and heuristicsEuropean Journal of Information Systems, 1994
- Novice errors in conceptual database designEuropean Journal of Information Systems, 1994
- Grand tour of concepts for object-orientation from a database point of viewData & Knowledge Engineering, 1993
- Relationship of relationships and other inter-relationship links in E-R modelData & Knowledge Engineering, 1992
- Representing extended entity-relationship structures in relational databasesACM Transactions on Database Systems, 1992
- Foreign keys decrease adaptability of database designsCommunications of the ACM, 1984
- Database abstractionsACM Transactions on Database Systems, 1977
- The entity-relationship model—toward a unified view of dataACM Transactions on Database Systems, 1976