Arithmeticnorm for learning database normalization

Hasan Saif Al-Bakri, Aisha (2021) Arithmeticnorm for learning database normalization. Project Report. Universiti Teknikal Malaysia Melaka, Melaka, Malaysia. (Submitted)

Text (Full Text) Arithmeticnorm for learning database normalization.pdf - Submitted Version Download (3MB)

Abstract

Normalization, which is a systematic way of decomposing tables, is the most extensively used process for examining relational databases. Its purpose is to design a set of relational tables with the least amount of data redundancy possible while retaining consistency. It also prevents undesirable features like insertion, update, and deletion anomalies. Thus, it is important for students to correctly implement the database normalization process. However, some students may have trouble with database normalization, which can lead to data duplication and the creation of databases that are larger than they need to be, slowing access. From our preliminary survey, 60% among FTMK lecturers agree that normalization is the most difficult topic in database and 90% agree that students have difficulties in learning normalization topis. While 81% among students agree that normalization is a difficult topic and 22% agree that normalization is the most difficult topic in database. Due to this matter, our study proposed a normalization tool named as ArithmeticNorm. Our ArithmeticNorm tool provides an environment for learning normalization of relational database to give students an interactive hands-on experience in database normalization process. From a total of 32 ArithmeticNorm users, 93% found that our tool will increase their productivity and 84% agree that ArithmeticNorm system will be useful in their studies.

Actions (login required)

View Item