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), 315-326.