Modeling and Teaching Techniques for Conceptual and Logical Relational Database Design

Authors:
Cheryl Bagley Thompson;Katherine Sward
Affiliations:
University of Nebraska Medical Center College of Nursing, Omaha 68198-5330;University of Utah College of Nursing, Salt Lake City, Utah
Venue:
Journal of Medical Systems
Year:
2005

Citing 8
Cited 0

Conceptual database design: an Entity-relationship approach

Conceptual database design: an Entity-relationship approach
Analysis of binary/ternary cardinality combinations in entity-relationship modeling

Data & Knowledge Engineering
UML toolkit

UML toolkit
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
Binary equivalents of ternary relationships in entity-relationship modeling: a logical decomposition approach

Journal of Database Management
A relational model of data for large shared data banks

Communications of the ACM
An Introduction to Database Systems

An Introduction to Database Systems
Database Systems: A Practical Approach to Design, Implementation and Management (4th Edition)

Database Systems: A Practical Approach to Design, Implementation and Management (4th Edition)

Quantified Score

Hi-index	0.00

Visualization

Abstract

This paper proposes a series of techniques to be used in teaching database design. Common ERD notations are discussed. The authors developed an ERD notation, adapted from the Unified Modeling Language, which facilitates student learning of the database design process. The paper presents a specific step by step process for representing the ERD components as tables and for normalizing the resulting set of tables.