An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
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)
ACM Computing Surveys (CSUR)
Conceptual schema and relational database design: a fact oriented approach
Conceptual schema and relational database design: a fact oriented approach
An introduction to database systems: vol. 1 (5th ed.)
An introduction to database systems: vol. 1 (5th ed.)
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
Using powerdomains to generalize relational databases
Theoretical Computer Science
Object-oriented modeling and design
Object-oriented modeling and design
A survey of database design transformations based on the Entity-Relationship model
Data & Knowledge Engineering
Conceptual modelling
A first course in database systems
A first course in database systems
Database management systems
An analysis of the structural validity of ternary relationships in entity relationship modeling
Proceedings of the seventh international conference on Information and knowledge management
Database modeling and design (3rd ed.)
Database modeling and design (3rd ed.)
Relational database reverse engineering: algorithms to extract cardinality constraints
Data & Knowledge Engineering
Client/server survival guide (3rd ed.)
Client/server survival guide (3rd ed.)
Complete rules for n-ary relationship cardinality constraints
Data & Knowledge Engineering
Storing semistructured data with STORED
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
ACM Computing Surveys (CSUR)
An introduction to database systems (7th ed.)
An introduction to database systems (7th ed.)
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
Improving database design through the analysis of relationships
ACM Transactions on Database Systems (TODS)
A relational model of data for large shared data banks
Communications of the ACM
A vision for management of complex models
ACM SIGMOD Record
SQL:1999: understanding relational language components
SQL:1999: understanding relational language components
Fundamentals of Database Systems
Fundamentals of Database Systems
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
CPI: constraints-preserving inlining algorithm for mapping XML DTD to relational schema
Data & Knowledge Engineering - ER2000
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
OO-METHOD: An OO Software Production Environment Combining Conventional and Formal Methods
CAiSE '97 Proceedings of the 9th International Conference on Advanced Information Systems Engineering
A Rule-Based Conversion of a DTD to a Conceptual Schema
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Semantics of the Minimum Multiplicity in Ternary Associations in UML
«UML» '01 Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools
Preserving relationship cardinality constraints in relational schemata
Database integrity
Hi-index | 0.00 |
Conceptual models are well-known tools to achieve a good design of information systems. Nevertheless, the understanding and use of all the constructs and constraints which are presented in such models are not an easy task and sometimes it is cause of loss of interest.In this chapter we have tried to study in depth and clarify the meaning of the features of conceptual models. The disagreements between main conceptual models, the confusion in the use of some of their constructs and some open problems in these models are shown. Another important topic treated in this chapter is the conceptual-to-logic schemata transformation process.Some solutions are presented in order to clarify the relationship construct and to extend the cardinality constraint concept in ternary relationships. How to preserve the cardinality constraint semantics in binary and ternary relationships for their implementation in a DBMS with active capabilities has also been developed.