Advisor(s) - Committee Chair
Dr. Guangming Xing (Director), Dr. Qi Li, Dr. Zhonghang Xia
School of Engineering and Applied Sciences
Master of Science
Database management is a very important subject in computer science education. The study of SQL syntax is the most important part of this course. The traditional teaching method only lets the students practice SQL syntax through the textbook exercise. Students cannot get the query result directly. Moreover, students do not know intuitively what is wrong with the query sentence. In this study, we want to find a better way for the teachers and the students to learn this part of database management. Teacher uploads a SQL file through a web page, it will create a database with several tables and some data records on the database server. The student logs in to the platform and chooses the database that he wants to practice. The student can do all regular database management operations such as query data, insert data, delete data, etc. If the query sentence is correct, the query result will be displayed on the webpage. If not, the detailed error information will show up. Since there is more than one student using the platform, so these operations cannot change the database created by the teacher. Therefore, the student’s process will run in a Docker container. In the container, there is a duplicated database of the teacher’s database. Meanwhile, the platform supports multiple users to do exercise with one database at the same time.
Zhang, Wenhui, "Design and Implementation of SQL Online Practice Platform" (2019). Masters Theses & Specialist Projects. Paper 3091.