A web-based tool for teaching data modeling
Journal of Computing Sciences in Colleges
An interactive tool to improve learning of data modeling: a survey study
Journal of Computing Sciences in Colleges
| Hi-index | 0.00 |
Normalization of relations to third normal form is often a difficult concept for students to grasp and working through examples helps. This tool is a simple tutorial implemented in JavaScript which takes the student through the multi-step process of beginning with a table of data and normalizing it to third normal form. The tutorial begins with a set of data derived from a report listing the overdue videos from a video store. First, the student identifies the repeating groups and then selects the attributes in the relation to be normalized. A computed value is included, which should be excluded from the relation. Then the student repeats the process of interactively identifying the attributes that are functionally dependent and removing them from the original relation and creating new relations until all relations are in third normal form. The tool provides feedback based on the student selections thereby guiding them to the correct answer.