A literature review on teaching and learning database normalisation : approaches and tools

Abstract

Database normalisation encompasses the process of arranging data in a recognised and structured way by increasing relations based on identified dependencies. Ineffective normalisation can lead to incompetent and inaccurate database systems. The worth of normalisation in improving and dealing with database systems is a topic of dispute in the studies of information systems. However, there is a dearth of exploration on the active teaching and learning aspects of database normalisation, principally on students’ independent enthusiasm and learning success in grasping the essential concepts. Teaching and learning database systems, particularly for novel students, have been acknowledged as a contest in the field. Instructors face problems in shaping what and how to successfully explain this subject. A systematic review methodology was used to explore the approaches and pedagogies utilised in teaching and learning database normalisation. The analysis intended to categorise, choose, and critically assess appropriate studies to gather and analyse data. The preliminary results propose that various studies rely on online applications for teaching and learning database normalisation. However, most of these studies emphasise more on the procedure of normalisation itself rather than the fundamental concepts. This study highlights the quest for more research on teaching and learning database normalisation, with precise attention to understanding the conceptual aspects. The recommendation stresses the reputation of exploring the essential concepts of normalisation relatively merely focusing on the technical aspects.