Entity-relationship diagrams which are in BCNF
International Journal of Parallel Programming
A logical design methodology for relational databases using the extended entity-relationship model
ACM Computing Surveys (CSUR)
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys (CSUR)
Database modeling and design: the entity-relationship approach
Database modeling and design: the entity-relationship approach
Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
On the foundations of the universal relation model
ACM Transactions on Database Systems (TODS)
Extending the database relational model to capture more meaning
ACM Transactions on Database Systems (TODS)
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
On the Equivalence of Database Models
Journal of the ACM (JACM)
Graph Algorithms
Relative information capacity of simple relational database schemata
PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
Assumptions in relational database theory
PODS '82 Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems
A Relation Merging Technique for Relational Databases
Proceedings of the Eighth International Conference on Data Engineering
Formal Properties of Net-Based Knowledge Representation Schemes
Proceedings of the Second International Conference on Data Engineering
Independent Database Schemes under Functional and Inclusion Dependencies
VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
On the Semantics of the Entity-Relationship Data Model
Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design
A Universal Relation Assumption Based on Entities and Relationships
Proceedings of the Fourth International Conference on Entity-Relationship Approach
Name Assignment Techniques for Relational Schemas Representing Extended Entity-Relationship Schemas
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Theory of Relational Databases
Theory of Relational Databases
Binary relationship imposition rules on ternary relationships in ER modeling
CIKM '93 Proceedings of the second international conference on Information and knowledge management
Converting relational to object-oriented databases
ACM SIGMOD Record
Managing semantic heterogeneity in databases: a theoretical prospective
PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Improving database design through the analysis of relationships
ACM Transactions on Database Systems (TODS)
A Unified Data Model for Representing Multimedia, Timeline, and Simulation Data
IEEE Transactions on Knowledge and Data Engineering
Derived types and taxonomic constraints in conceptual modeling
Information Systems - The 13th international conference on advanced information systems engineering (CAiSE*01)
The Use of Information Capacity in Schema Integration and Translation
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Taxonomies and Derivation Rules in Conceptual Modeling
CAiSE '01 Proceedings of the 13th International Conference on Advanced Information Systems Engineering
The Natural Language Modeling Procedure
NGITS '02 Proceedings of the 5th International Workshop on Next Generation Information Technologies and Systems
Ternary relationships: semantic requirements and logically correct alternatives
Advanced topics in database research vol. 1
Conceptual process configurations in enterprise knowledge management systems
Proceedings of the 2006 ACM symposium on Applied computing
Enriching the ER model based on discovered association rules
Information Sciences: an International Journal
Query answering under expressive entity-relationship schemata
ER'10 Proceedings of the 29th international conference on Conceptual modeling
Ontological query answering under expressive Entity-Relationship schemata
Information Systems
A conceptual justification for model transformations
APCCM '12 Proceedings of the Eighth Asia-Pacific Conference on Conceptual Modelling - Volume 130
Hi-index | 0.01 |
A common approach to database design is to describe the structures and constraints of the database application in terms of a semantic data model, and then represent the resulting schema using the data model of a commercial database management system. Often, in practice, Extended Entity-Relationship (EER) schemas are translated into equivalent relational schemas. This translation involves different aspects: representing the EER schema using relational constructs, assigning names to relational attributes, normalization, and merging relations. Considering these aspects together, as is usually done in the design methodologies proposed in the literature, is confusing and leads to inaccurate results. We propose to treat separately these aspects and split the translation into four stages (modules) corresponding to the four aspects mentioned above. We define criteria for both evaluating the correctness of and characterizing the relationship between alternative relational representations of EER schemas.