Do, Q., & Agrawal, R. K., & Rao, D., & Gudivada, V. N. (2014, June), Automatic Generation of SQL Queries  Paper presented at 2014 ASEE Annual Conference & Exposition, Indianapolis, Indiana. 10.18260/1-2--20112

\bibitem{asee_peer_20112}
  Do, Q., \& Agrawal, R. K., \& Rao, D., \& Gudivada, V. N. (2014, June), \emph{Automatic Generation of SQL Queries}
  Paper presented at 2014 ASEE Annual Conference \& Exposition, Indianapolis, Indiana.
  10.18260/1-2--20112

Quan Do, Rajeev K. Agrawal, Dhana Rao, and Venkat N Gudivada.  "Automatic Generation of SQL Queries".  2014 ASEE Annual Conference & Exposition, Indianapolis, Indiana, 2014, June.  ASEE Conferences, 2014.  https://peer.asee.org/20112 Internet.  07 Jan, 2025

\bibitem{asee_peer_20112}
  Quan Do, Rajeev K. Agrawal, Dhana Rao, and Venkat N Gudivada.
  "Automatic Generation of SQL Queries".
  \emph{2014 ASEE Annual Conference \& Exposition, Indianapolis, Indiana, 2014, June}.
  ASEE Conferences, 2014.
  https://peer.asee.org/20112 Internet.  07 Jan, 2025

@INPROCEEDINGS{asee_peer_20112
author = "Quan Do, Rajeev K. Agrawal, Dhana Rao, and Venkat N Gudivada"
title = "Automatic Generation of SQL Queries"
booktitle = "2014 ASEE Annual Conference \& Exposition"
year = "2014"
month = "June"
address = "Indianapolis, Indiana"
publisher = "ASEE Conferences"
note = {https://peer.asee.org/20112}
number = {10.18260/1-2--20112}
}

TY  - CPAPER
AB  -                          Automatic Generation of SQL QueriesAutomatic question generation is an active area of research. Its practical applications are many,especially in the context of learning assessment. In both online and traditional face-to-facecourses, learning outcomes are used as standards for measuring and comparing performance andachievement of learners. In a broader context, outcomes-based assessment is widely used inevaluating and improving academic degree programs. The former plays a central role especiallyin ABET accreditation of undergraduate engineering and computer science degree programs.Structured Query Language (SQL) is an ANSI and ISO standard declarative query language forquerying and manipulating relational databases. It is easy to write SQL queries but very difficultto validate them. Often students conclude that a SQL query is correct simply because the querycompiles, executes, and fetches data. Therefore, it is crucial that SQL assessment tasks arecarefully designed and implemented to insure a deep learning experience for students. In thispaper, we propose an approach to automatically generating SQL queries for assessing students'SQL learning. SQL concepts are modeled using RDFS. The user can select SQL concepts to beincluded in an assessment and our approach will generate appropriate queries. The proposedapproach is generic and is database metadata driven. A Web-based prototype system isdeveloped to illustrate the effectiveness of the proposed approach.The overarching goal for our work is driven by the following considerations: questions should begenerated on the fly, no question bank should be involved; answers to the questions should alsobe generated automatically; generated questions should feature all ANSI/ISO SQL concepts,individually or in permissible combinations; question generation system should work with anyrelational database created using any open source or commercial database management systems(that adhere to ANSI and ISO SQL standards); in addition to the generated questions andsolutions, the system should provide additional information to facilitate self-directed guidedlearning.
AU  - Quan Do
AU  - Rajeev K. Agrawal
AU  - Dhana Rao
AU  - Venkat N Gudivada
CY  - Indianapolis, Indiana
DA  - 2014/06/15
PB  - ASEE Conferences
TI  - Automatic Generation of SQL Queries
UR  - https://peer.asee.org/20112
DO  - 10.18260/1-2--20112
ER  -