Foreign keys decrease adaptability of database designs
Communications of the ACM - Special section on management of information systems
A logical design methodology for relational databases using the extended entity-relationship model
ACM Computing Surveys (CSUR)
Relative information capacity of simple relational database schemata
SIAM Journal on Computing
A methodology for creating user views in database design
ACM Transactions on Database Systems (TODS)
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys (CSUR)
Comparing representations with relational and EER models
Communications of the ACM
Conceptual schema and relational database design: a fact oriented approach
Conceptual schema and relational database design: a fact oriented approach
On the satisfiability of dependency constraints in entity-relationship schemata
Information Systems
Relational database design: an introduction
Relational database design: an introduction
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
Representing extended entity-relationship structures in relational databases: a modular approach
ACM Transactions on Database Systems (TODS)
Grand tour of concepts for object-orientation from a database point of view
Data & Knowledge Engineering
Relationship of relationships and other inter-relationship links in E-R model
Data & Knowledge Engineering
Fundamentals of database systems (2nd ed.)
Fundamentals of database systems (2nd ed.)
A conceptual model for the logical design of temporal databases
Decision Support Systems - Special issue on WITS '92
Using objects for systems analysis
Communications of the ACM
Database design with common sense business reasoning and learning
ACM Transactions on Database Systems (TODS)
An approach for decomposing N-ary data relationships
Software—Practice & Experience
Complete rules for n-ary relationship cardinality constraints
Data & Knowledge Engineering
Expressing casual relationships in conceptual database schemas
Journal of Systems and Software
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Database abstractions: aggregation and generalization
ACM Transactions on Database Systems (TODS)
Data Models
A Psychological Study on the Use of Relationship Concept - Some Preliminary Findings
CAiSe '95 Proceedings of the 7th International Conference on Advanced Information Systems Engineering
Some Findings on the Intuitivness of Entity-Relationship Constructs
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Fundamentals of Cardinality Constraints
ER '92 Proceedings of the 11th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Schema Transformation Techniques for Database Reverse Engineering
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
A Semantic Comparison of the Modelling Capabilities of the ER and NIAM Models
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Searching for Compositions in ER Schemes
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
A Methodology for Learning Across Application Domains for Database Design Systems
IEEE Transactions on Knowledge and Data Engineering
Integrity Constraint Enforcement by Means of Trigger Templates
ADVIS '02 Proceedings of the Second International Conference on Advances in Information Systems
Database Conceptual Modeling for Integrating E-A Model and E-R Model
ICOIN '02 Revised Papers from the International Conference on Information Networking, Wireless Communications Technologies and Network Applications-Part I
Preserving relationship cardinality constraints in relational schemata
Database integrity
Dealing with relationship cardinality constraints in relational database design
Effective databases for text & document management
International Journal of Human-Computer Studies
Comparing Relationships in Conceptual Modeling: Mapping to Semantic Classifications
IEEE Transactions on Knowledge and Data Engineering
The use of a knowledge-based system in conceptual data modeling
Decision Support Systems
ACM Transactions on Database Systems (TODS)
Complementary utilities for UML an UP in information systems
EATIS '07 Proceedings of the 2007 Euro American conference on Telematics and information systems
The use of a knowledge-based system in conceptual data modeling
Decision Support Systems
Design science in information systems research
MIS Quarterly
| Hi-index | 0.00 |
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.