Virtual Lab of DBMS: A Web- Based Interactive Virtual Lab for Database Management System

Abstract

With the increasing demand for hands-on learning in database management systems (DBMS), traditional teaching methods often fall short in providing practical experience. Virtual lab of DBMS is a web-based interactive virtual lab designed to bridge this gap by offering students a platform to practice and execute SQL queries in a controlled environment. Developed using HTML, CSS, and JavaScript for the frontend, with PHP for the backend and XAMPP for database query execution, Virtual lab of DBMS provides an intuitive interface for learners. The system features a dashboard, theory modules, simulation exercises, and interactive quizzes that reinforce database concepts through real-time practice. Additionally, an activity section includes hands-on tasks covering Joins, WHERE Clause, ORDER BY, COUNT functions, and more, allowing students to strengthen their query formulation skills. The platform enhances self-paced learning by offering instant feedback and quiz-based assessments. This research discusses the effectiveness of Virtual lab of DBMS in improving DBMS education by promoting interactive, practice-driven learning experiences.