Bridging entity-relationship and relational data models

Hsiang-Jui Kung; Adrian Gardnier; Hui-Lien Tung

Bridging entity-relationship and relational data models

Hsiang-Jui Kung, Adrian Gardnier, Hui-Lien Tung

Management

Research output: Contribution to book or proceeding › Conference article › 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
Title of host publication	Proceedings of the International Academy of Information Management Annual Conference
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

Publication series

Name	Proceedings of the International Academy of Information Management Annual Conference

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

Disciplines

Business Administration, Management, and Operations
Management Information Systems

Keywords

Data model
Entity relationship diagram
Normalization
Relational model

Cite this

@inproceedings{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 = "Hsiang-Jui Kung and Adrian Gardnier and Hui-Lien Tung",

year = "2005",

language = "English",

series = "Proceedings of the International Academy of Information Management Annual Conference",

pages = "303--311",

booktitle = "Proceedings of the International Academy of Information Management Annual Conference",

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

}

Kung, H-J, Gardnier, A & Tung, H-L 2005, Bridging entity-relationship and relational data models. in Proceedings of the International Academy of Information Management Annual Conference. Proceedings of the International Academy of Information Management Annual Conference, pp. 303-311, 20th International Conference on Informatics Education Research, ICIER 2005, Las Vegas, NV, United States, 12/9/05.

Bridging entity-relationship and relational data models. / Kung, Hsiang-Jui; Gardnier, Adrian; Tung, Hui-Lien.
Proceedings of the International Academy of Information Management Annual Conference. 2005. p. 303-311 (Proceedings of the International Academy of Information Management Annual Conference).

Research output: Contribution to book or proceeding › Conference article › peer-review

TY - GEN

T1 - Bridging entity-relationship and relational data models

AU - Kung, Hsiang-Jui

AU - Gardnier, 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 - https://digitalcommons.georgiasouthern.edu/info-sys-facpubs/133

M3 - Conference article

AN - SCOPUS:84865701128

T3 - Proceedings of the International Academy of Information Management Annual Conference

SP - 303

EP - 311

BT - Proceedings of the International Academy of Information Management Annual Conference

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

Publication series

Conference

Scopus Subject Areas

Disciplines

Keywords

Other files and links

Fingerprint

Cite this