Online Archive of University of Virginia Scholarship
Using Context Free Grammars to Generate SQL Questions332 views
Author
Conway, Jared, School of Engineering and Applied Science, University of Virginia
Advisors
Basit, Nada, EN-Comp Science Dept, University of Virginia
Abstract
This paper showcases the limitations of current SQL practice approaches, both in server architecture and implementation. The technical project works towards resolving these limitations by providing a fully client-sided website to help students practice SQL. By providing a client only architecture rather than the traditional server-client approach, queries are guaranteed to be sandboxed, and the necessity for reliable WiFi becomes nearly nonexistent. This is in part an extension of the SQL Injection platform first presented in 2019 [1], with more focus on practicing SQL queries than SQL injection attacks. Such practice involves basic keywords, including WHERE, HAVING, and GROUP BY as well as aggregates. This approach implements modified context free grammars for constructing questions and example answers, including variables for aggregates and GROUP BY.
Conway, Jared. Using Context Free Grammars to Generate SQL Questions. University of Virginia, School of Engineering and Applied Science, BS (Bachelor of Science), 2024-12-27, https://doi.org/10.18130/akcx-j052.
