Journal of Information Systems Education (JISE)

Volume 17

Volume 17 Number 3, Pages 315-326

Fall 2006


An Alternative Approach to Teaching Database Normalization: A Simple Algorithm and an Interactive eLearning Tool


Hsiang-Jui Kung
Georgia Southern University
Statesboro, GA 30460, USA

Hui-Lien Tung
Paine College
Augusta, GA 30901, USA

Abstract: The relational data model is an important concept covered in the systems analysis and design course. It has been difficult to motivate students to learn database normalization because they find the subject dry and theoretical. An alternative approach has been developed to give students an easy-to-follow algorithm and an interactive, hands-on e-learning tool. The approach is suitable for database normalization in systems analysis and design and in database management courses. This paper describes the alternative approach and its effectiveness in teaching database normalization. The effectiveness of the approach has been evaluated in an exercise and a survey. The paper shows that the approach reduces error rate and increases students' perceived ease, confidence and performance of the normalization approach.

Keywords: Database normalization, Relational data model, Functional dependency, Third normal form

Download this article: JISE - Volume 17 Number 3, Page 315.pdf


Recommended Citation: Kung, H. -J. & Tung, H. -L. (2006). An Alternative Approach to Teaching Database Normalization: A Simple Algorithm and an Interactive eLearning Tool. Journal of Information Systems Education, 17(3), pp. 315-326.