Intelligent tutoring system for Database Normalization

Autor: Abhijit Joshi, Meera Narvekar, Neha Mendjoge
Rok vydání: 2016
Předmět:
Zdroj: 2016 International Conference on Computing Communication Control and automation (ICCUBEA).
Popis: A database is said to be efficient, if it performs operations like delete, update and insert in an unambiguous way. These operations can be performed efficiently by normalizing the database. By normalization, the tables in a database are organized in a well-structured manner that reduces the generation of redundant data as well as ensures that the data dependencies make sense, i.e., all the functional dependencies are satisfied. It is observed that students find it difficult to understand the concepts of normal forms while learning a Database Management Course and also they find it difficult to obtain smaller well-structured relations by applying normalization concept. Very few commercial design tools are available to assist students in learning Normalization. Consequence is a big challenge for educators, in both, teaching as well as motivating students in learning Data Base Design. Keeping in mind all these aspects, we decided to develop an intelligent tutor, which will teach users the process of normalization and help them in normalizing the databases. While solving the problems, the tutor will also provide hints and feedback, if the user demands. The tutor also keeps track of the performance of the user to plan its teaching strategies.
Databáze: OpenAIRE