A logical design methodology for relational databases using the extended entity-relationship model
ACM Computing Surveys (CSUR)
Artifact as theory-nexus: hermeneutics meets theory-based design
CHI '89 Proceedings of the SIGCHI Conference on Human Factors in Computing Systems
Comparing representations with relational and EER models
Communications of the ACM
Database modeling and design: the entity-relationship approach
Database modeling and design: the entity-relationship approach
Database management (3rd ed.)
The management of end-user computing: status and directions
ACM Computing Surveys (CSUR)
Tools and transformations—rigorous and otherwise—for practical database design
ACM Transactions on Database Systems (TODS)
Improving conceptual database design through feedback
International Journal of Human-Computer Studies
Design patterns: elements of reusable object-oriented software
Design patterns: elements of reusable object-oriented software
Deriving functional dependencies from the entity-relationship model
Communications of the ACM
Analysis of binary/ternary cardinality combinations in entity-relationship modeling
Data & Knowledge Engineering
Entity-relationship and object-oriented data modeling—an experimental comparison of design quality
Data & Knowledge Engineering
Database research faces the information explosion
Communications of the ACM
Analysis patterns: reusable objects models
Analysis patterns: reusable objects models
Object models (2nd ed.): strategies, patterns, and applications
Object models (2nd ed.): strategies, patterns, and applications
Database modeling and design (3rd ed.)
Database modeling and design (3rd ed.)
Database description with SDM: a semantic database model
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
Enterprise resource planning: introduction
Communications of the ACM
A relational model of data for large shared data banks
Communications of the ACM
International Journal of Human-Computer Studies
Data Model Patterns: Conventions of Thought
Data Model Patterns: Conventions of Thought
Enterprise-Wide Data Modelling
Enterprise-Wide Data Modelling
Information Processing and Human-Machine Interaction: An Approach to Cognitive Engineering
Information Processing and Human-Machine Interaction: An Approach to Cognitive Engineering
Modern Database Management
Intelligent Support for Retrieval and Synthesis of Patterns for Object-Oriented Design
ER '97 Proceedings of the 16th International Conference on Conceptual Modeling
Theory of Relational Databases
Theory of Relational Databases
ER'00 Proceedings of the 19th international conference on Conceptual modeling
International Journal of Human-Computer Studies
The use of a knowledge-based system in conceptual data modeling
Decision Support Systems
Could the use of a knowledge-based system lead to implicit learning?
Decision Support Systems
Information Systems Research
The use of a knowledge-based system in conceptual data modeling
Decision Support Systems
A knowledge-based object modeling advisor for developing quality object models
Expert Systems with Applications: An International Journal
A knowledge-based system for improving the consistency between object models and use case narratives
Expert Systems with Applications: An International Journal
Hi-index | 0.00 |
The paper describes the main features of a prototype tool CODASYS (COnceptual modeling tool for DAtabase SYStems), which purports to help novice designers engaged in conceptual data modeling. It is well known that conceptual data modeling is an error-prone process for novice database designers. The tool assists a designer in developing an entity-relationship diagram that can be translated to a normalized relational representation, free of derived dependencies. We first discuss a set of requirements for the tool that is based on achieving normal forms, on preventing data modeling errors, and on a theoretical foundation. We then discuss how the tool achieves the four normal forms and prevents common database errors such as incorrect degree, incorrect connectivity, and derived relationships. Further, we provide a cognitive framework for understanding novice error behavior and elaborate on how CODASYS addresses cognitive strain in database design. Next, we present the features of the tool and, with the help of flowcharts, discuss how these features have been implemented using a rule-based approach. It may be noted that empirical studies have been conducted to test the efficacy of the tool and have indicated significant improvement in novice designer performance.