Problem-Based e-Learning and Evaluation System forDatabase Design and Programming in SQL

Abstract

 Abstract—Problem-based e-Learning (PBeL) can be a highly successful model for the teaching and learning of Database, one of the core courses of Computer Science and Engineering in undergraduate level. There are very few e-Learning systems found to support the learning of the different components of Database course. Existing systems provide only the partial solution of extensive learning of this course and also do not support the automatic evaluation of student performance. The main components of database practical course are: database design, SQL, PL/SQL and implementation of database projects. In this research, we have developed a system: SQL Learning and Evaluation System (SQL-LES) for effective teaching and learning of all of the above components of the practical parts of the database course. We have developed a question bank covering all areas of SQL questions and answers. The question bank can be used for both learning and automatic evaluation of student's performance by creating test sets and assigning the test sets to the individual students. The system can effectively be used for the teaching, learning and evaluation of database design, PL/SQL and database projects as well. SQL-LES has been applied in teaching, learning and evaluation of database laboratory course in undergraduate level of the Department of Computer Science and Engineering (CSE), Bangladesh University of Engineering and Technology (BUET) in several years and found to be very effective in classroom environment. Index Terms—E-learning, problem based learning (PBL),