A practical guide to logical data modeling
A practical guide to logical data modeling
Cardinality constraints in semantic data models
Data & Knowledge Engineering
Analysis of binary/ternary cardinality combinations in entity-relationship modeling
Data & Knowledge Engineering
An analysis of cardinality constraints in redundant relationships
CIKM '97 Proceedings of the sixth international conference on Information and knowledge management
Database modeling and design (3rd ed.)
Database modeling and design (3rd ed.)
Complete rules for n-ary relationship cardinality constraints
Data & Knowledge Engineering
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
Journal of Database Management
Case Method: Entity Relationship Modelling
Case Method: Entity Relationship Modelling
Data Analysis for Data Base Design
Data Analysis for Data Base Design
Software Engineering Economics
Software Engineering Economics
Fundamentals of Database Systems
Fundamentals of Database Systems
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
Database Systems Concepts
On the Interaction Between ISA and Cardinality Constraints
Proceedings of the Tenth International Conference on Data Engineering
Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach
Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design
A Description of Rules through Occurring/Synthetic Cardinalities
Proceedings of the Seventh International Conference on Enity-Relationship Approach: A Bridge to the User
Evaluation of Complex Cardinality Constraints
ER '92 Proceedings of the 11th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Fundamentals of Cardinality Constraints
ER '92 Proceedings of the 11th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Analysis of Binary Relationships within Ternary Relationships in ER Modeling
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Cardinality Consistency of Derived Objects in DOOD Systems
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
On the Consistency of Int-cardinality Constraints
ER '98 Proceedings of the 17th International Conference on Conceptual Modeling
On the global coherence of integrity constraints in UML class diagrams
DBA'06 Proceedings of the 24th IASTED international conference on Database and applications
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
IITA'09 Proceedings of the 3rd international conference on Intelligent information technology application
Fuzzy functional dependencies in multiargument relationships
ICAISC'10 Proceedings of the 10th international conference on Artificial intelligence and soft computing: Part I
RSFDGrC'11 Proceedings of the 13th international conference on Rough sets, fuzzy sets, data mining and granular computing
EERMM: a metamodel for the enhanced entity-relationship model
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
Hi-index | 0.00 |
We explore the criteria that contribute to the structural validity of modeling structures within the entity-relationship (ER) diagram. Our approach examines cardinality constraints in conjunction with the degree of the relationship to address constraint consistency, state compliance, and role uniqueness issues to derive a complete and comprehensive set of decision rules. Unlike typical other analyses that use only maximum cardinality constraints, we have used both maximum and minimum cardinality constraints in defining the properties and their structural validity criteria yielding a complete analysis of the structural validity of recursive, binary, and ternary relationship types. Our study evaluates these relationships as part of the overall diagram and our rules address these relationships as they coexist in a path structure within the model. The contribution of this paper is to provide a comprehensive set of decision rules to determine the structural validity of any ERD containing recursive, binary, and ternary relationships. These decision rules can be readily applied to real world data models regardless of their complexity. The rules can easily be incorporated into the database modeling and designing process, or extended into case tool implementations.