An Implementation of Self-study Exercise Problems for Entry-level SQL-Python Database Programming.

Saved in:

Bibliographic Details
Title:	An Implementation of Self-study Exercise Problems for Entry-level SQL-Python Database Programming.
Authors:	Ni Wayan Wardani¹ pj5w1e4c@s.okayama-u.ac.jp, Nobuo Funabiki² funabiki@okayama-u.ac.jp, Putu Sugiartawan¹ p18z9yov@s.okayama-u.ac.jp, Pradhana, Anak Agung Surya¹ p44c722y@s.okayama-u.ac.jp, Kotama, I. Nyoman Darma¹ p9363bg2@s.okayama-u.ac.jp, Putra, I. Nyoman Agus Suarya³ nyomansuarya@instiki.ac.id
Source:	Engineering Letters. Aug2025, Vol. 33 Issue 8, p2939-2948. 10p.
Subjects:	SQL, Python programming language, Database design, Learning, User-centered system design, Autodidacticism
Abstract:	Currently, SQL and Python are popular in many universities and professional schools worldwide. SQL is an effective domain-specific language used for relational database management and querying. Python is a high-level, flexible programming language well known for its abundance of libraries and ease of use. When integrated, they provide a comprehensive approach to study database management by students. This study implements the grammar-concept understanding problem (GUP) and the comment insertion problem (CIP) for the first-step self-studies of entry-level SQL-Python database programming. These problems are designed to understand the keywords and behaviors of the given source code. In GUP, each question asks to answer the corresponding key element in the given code representing the defined grammatical idea. In CIP, each question asks for the proper comment to be inserted in the code's corresponding place. A string matching with the correct one automatically marks any answer. For evaluations of our GUP/CIP approach for the first-step SQL-Python database programming, we developed 18 instances each of GUP and CIP for basic concepts. The approach was tested with 60 students at the Indonesian Institute of Business and Technology, who completed GUP and CIP exercises and assessed system usability via the System Usability Scale (SUS), achieving a satisfactory score of 84. Furthermore, surveys showed self-study enabled flexible learning and practice, over 85% of students reporting improved final exam grades. The findings suggest GUP and CIP enhance self-paced database programming education. [ABSTRACT FROM AUTHOR]
	Copyright of Engineering Letters is the property of International Association of Engineers (IAENG) and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Database:	Engineering Source

Description
Abstract:	Currently, SQL and Python are popular in many universities and professional schools worldwide. SQL is an effective domain-specific language used for relational database management and querying. Python is a high-level, flexible programming language well known for its abundance of libraries and ease of use. When integrated, they provide a comprehensive approach to study database management by students. This study implements the grammar-concept understanding problem (GUP) and the comment insertion problem (CIP) for the first-step self-studies of entry-level SQL-Python database programming. These problems are designed to understand the keywords and behaviors of the given source code. In GUP, each question asks to answer the corresponding key element in the given code representing the defined grammatical idea. In CIP, each question asks for the proper comment to be inserted in the code's corresponding place. A string matching with the correct one automatically marks any answer. For evaluations of our GUP/CIP approach for the first-step SQL-Python database programming, we developed 18 instances each of GUP and CIP for basic concepts. The approach was tested with 60 students at the Indonesian Institute of Business and Technology, who completed GUP and CIP exercises and assessed system usability via the System Usability Scale (SUS), achieving a satisfactory score of 84. Furthermore, surveys showed self-study enabled flexible learning and practice, over 85% of students reporting improved final exam grades. The findings suggest GUP and CIP enhance self-paced database programming education. [ABSTRACT FROM AUTHOR]
ISSN:	1816093X