Modeling and teaching techniques for conceptual and logical relational database design

Cheryl Thompson, Katherine Sward

Research output: Contribution to journalArticle

4 Citations (Scopus)

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.

Original languageEnglish (US)
Pages (from-to)513-525
Number of pages13
JournalJournal of Medical Systems
Volume29
Issue number5
DOIs
StatePublished - Oct 1 2005

Fingerprint

Teaching
Databases
Unified Modeling Language
Language
Learning
Students

Keywords

  • Entity relationship diagrams
  • Relational database design
  • Unified modeling language

ASJC Scopus subject areas

  • Medicine (miscellaneous)
  • Information Systems
  • Health Informatics
  • Health Information Management

Cite this

Modeling and teaching techniques for conceptual and logical relational database design. / Thompson, Cheryl; Sward, Katherine.

In: Journal of Medical Systems, Vol. 29, No. 5, 01.10.2005, p. 513-525.

Research output: Contribution to journalArticle

@article{68fbec90963b46739487f82c7808d24d,
title = "Modeling and teaching techniques for conceptual and logical relational database design",
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.",
keywords = "Entity relationship diagrams, Relational database design, Unified modeling language",
author = "Cheryl Thompson and Katherine Sward",
year = "2005",
month = "10",
day = "1",
doi = "10.1007/s10916-005-6108-3",
language = "English (US)",
volume = "29",
pages = "513--525",
journal = "Journal of Medical Systems",
issn = "0148-5598",
publisher = "Springer New York",
number = "5",

}

TY - JOUR

T1 - Modeling and teaching techniques for conceptual and logical relational database design

AU - Thompson, Cheryl

AU - Sward, Katherine

PY - 2005/10/1

Y1 - 2005/10/1

N2 - 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.

AB - 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.

KW - Entity relationship diagrams

KW - Relational database design

KW - Unified modeling language

UR - http://www.scopus.com/inward/record.url?scp=23944510277&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=23944510277&partnerID=8YFLogxK

U2 - 10.1007/s10916-005-6108-3

DO - 10.1007/s10916-005-6108-3

M3 - Article

VL - 29

SP - 513

EP - 525

JO - Journal of Medical Systems

JF - Journal of Medical Systems

SN - 0148-5598

IS - 5

ER -