• Refine Query
  • Source
  • Publication year
  • to
  • Language
  • No language data
  • Tagged with
  • 1
  • 1
  • 1
  • 1
  • 1
  • 1
  • About
  • The Global ETD Search service is a free service for researchers to find electronic theses and dissertations. This service is provided by the Networked Digital Library of Theses and Dissertations.
    Our metadata is collected from universities around the world. If you manage a university/consortium/country archive and want to be added, details can be found on the NDLTD website.
1

Design and Implementation of SQL Online Practice Platform

Zhang, Wenhui 01 April 2019 (has links)
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.

Page generated in 0.0482 seconds