Bridging entity-relationship and relational data models

Hsiang Jui Kung; Adrian Gardiner; Hui Lien Tung

Bridging entity-relationship and relational data models

Hsiang Jui Kung, Adrian Gardiner, Hui Lien Tung

Emeriti, Retired & In Memoriam (PCOB)

Research output: Contribution to conference › Paper › peer-review

Abstract

Conceptual database design is a difficult task for novice database designers. To identify the problem areas in conceptual database design, the authors break down the design task into three subtasks: simplified entity-relationship diagram (ERD), normalization (relational model) and enhanced (normalized) entity-relationship diagram (EERD). This paper describes research design, results of a laboratory study that employed novice database designers to identify their performance and the problem areas from exercise and survey. Results indicate that relational model and EERD are the error-prone area for most of the students.

Original language	English
Pages	303-311
Number of pages	9
State	Published - 2005
Event	20th International Conference on Informatics Education Research, ICIER 2005 - Las Vegas, NV, United States Duration: Dec 9 2005 → Dec 11 2005

Conference

Conference	20th International Conference on Informatics Education Research, ICIER 2005
Country/Territory	United States
City	Las Vegas, NV
Period	12/9/05 → 12/11/05

Scopus Subject Areas

Information Systems
Education

Keywords

Data model
Entity relationship diagram
Normalization
Relational model

Cite this

@conference{133baff15b0b4ede826bf61d1e2654e8,

title = "Bridging entity-relationship and relational data models",

abstract = "Conceptual database design is a difficult task for novice database designers. To identify the problem areas in conceptual database design, the authors break down the design task into three subtasks: simplified entity-relationship diagram (ERD), normalization (relational model) and enhanced (normalized) entity-relationship diagram (EERD). This paper describes research design, results of a laboratory study that employed novice database designers to identify their performance and the problem areas from exercise and survey. Results indicate that relational model and EERD are the error-prone area for most of the students.",

keywords = "Data model, Entity relationship diagram, Normalization, Relational model",

author = "Kung, {Hsiang Jui} and Adrian Gardiner and Tung, {Hui Lien}",

year = "2005",

language = "English",

pages = "303--311",

note = "20th International Conference on Informatics Education Research, ICIER 2005 ; Conference date: 09-12-2005 Through 11-12-2005",

}

TY - CONF

T1 - Bridging entity-relationship and relational data models

AU - Kung, Hsiang Jui

AU - Gardiner, Adrian

AU - Tung, Hui Lien

PY - 2005

Y1 - 2005

N2 - Conceptual database design is a difficult task for novice database designers. To identify the problem areas in conceptual database design, the authors break down the design task into three subtasks: simplified entity-relationship diagram (ERD), normalization (relational model) and enhanced (normalized) entity-relationship diagram (EERD). This paper describes research design, results of a laboratory study that employed novice database designers to identify their performance and the problem areas from exercise and survey. Results indicate that relational model and EERD are the error-prone area for most of the students.

AB - Conceptual database design is a difficult task for novice database designers. To identify the problem areas in conceptual database design, the authors break down the design task into three subtasks: simplified entity-relationship diagram (ERD), normalization (relational model) and enhanced (normalized) entity-relationship diagram (EERD). This paper describes research design, results of a laboratory study that employed novice database designers to identify their performance and the problem areas from exercise and survey. Results indicate that relational model and EERD are the error-prone area for most of the students.

KW - Data model

KW - Entity relationship diagram

KW - Normalization

KW - Relational model

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

M3 - Paper

AN - SCOPUS:84865701128

SP - 303

EP - 311

T2 - 20th International Conference on Informatics Education Research, ICIER 2005

Y2 - 9 December 2005 through 11 December 2005

ER -

Bridging entity-relationship and relational data models

Abstract

Conference

Scopus Subject Areas

Keywords

Other files and links

Fingerprint

Cite this