Harnessing SQL for Automated Web Development: An Interactive Learning Platform for Database Students

The study of database systems encompasses both strong theoretical foundations and practical applications. Students must develop a solid understanding of theoretical concepts while also acquiring robust practical skills. However, traditional teaching methods, characterized by a "Chalk and Talk" approach, often hinder this dual development. Without a comprehensive narrative to contextualize the material, students may struggle to grasp the abstract concepts inherent in database systems. To improve students’ understanding, it is crucial to involve students in the hands-on process of building a database application from scratch. However, it is challenging for students to complete a database application project in one semester without adequate programming skills. Our objective is to allow students to focus on learning database programming rather than diverting their efforts toward other areas such as web programming or infrastructure configuration.

The proposed framework leverages generative AI technologies, such as OpenAI’s ChatGPT and Grok, to assist educators in developing comprehensive web applications integrated with databases, significantly reducing instructors’ workloads. By utilizing Large Language Models (LLMs), the framework facilitates the creation of entity-relationship diagrams, the generation of DDL (Data Definition Language) and DML (Data Manipulation Language) statements, and the generation of Python Flask render templates along with backend code.
In addition to these capabilities, the framework allows educators to obscure specific portions of SQL queries, enabling students to input their SQL attempts through a dedicated portal; it maps these attempts to the obscured sections and updates the application in real-time to reflect query results. This interactive process not only reinforces learning, but also provides immediate feedback, helping students understand their mistakes and effectively enhance their SQL skills.

This innovative approach simplifies the educator’s workload by setting up a comprehensive web application with SQL exercises for students. From the students’ perspective, they are motivated to engage with the assessments and can visualize how their inputs affect the real web application.