View in EDS PDF Full Text

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 Wardani1 pj5w1e4c@s.okayama-u.ac.jp, Nobuo Funabiki2 funabiki@okayama-u.ac.jp, Putu Sugiartawan1 p18z9yov@s.okayama-u.ac.jp, Pradhana, Anak Agung Surya1 p44c722y@s.okayama-u.ac.jp, Kotama, I. Nyoman Darma1 p9363bg2@s.okayama-u.ac.jp, Putra, I. Nyoman Agus Suarya3 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
FullText Links:
  – Type: pdflink
Text:
  Availability: 0
Header DbId: egs
DbLabel: Engineering Source
An: 187082225
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 0
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: An Implementation of Self-study Exercise Problems for Entry-level SQL-Python Database Programming.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Ni+Wayan+Wardani%22">Ni Wayan Wardani</searchLink><relatesTo>1</relatesTo><i> pj5w1e4c@s.okayama-u.ac.jp</i><br /><searchLink fieldCode="AR" term="%22Nobuo+Funabiki%22">Nobuo Funabiki</searchLink><relatesTo>2</relatesTo><i> funabiki@okayama-u.ac.jp</i><br /><searchLink fieldCode="AR" term="%22Putu+Sugiartawan%22">Putu Sugiartawan</searchLink><relatesTo>1</relatesTo><i> p18z9yov@s.okayama-u.ac.jp</i><br /><searchLink fieldCode="AR" term="%22Pradhana%2C+Anak+Agung+Surya%22">Pradhana, Anak Agung Surya</searchLink><relatesTo>1</relatesTo><i> p44c722y@s.okayama-u.ac.jp</i><br /><searchLink fieldCode="AR" term="%22Kotama%2C+I%2E+Nyoman+Darma%22">Kotama, I. Nyoman Darma</searchLink><relatesTo>1</relatesTo><i> p9363bg2@s.okayama-u.ac.jp</i><br /><searchLink fieldCode="AR" term="%22Putra%2C+I%2E+Nyoman+Agus+Suarya%22">Putra, I. Nyoman Agus Suarya</searchLink><relatesTo>3</relatesTo><i> nyomansuarya@instiki.ac.id</i>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <searchLink fieldCode="JN" term="%22Engineering+Letters%22">Engineering Letters</searchLink>. Aug2025, Vol. 33 Issue 8, p2939-2948. 10p.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22SQL%22">SQL</searchLink><br /><searchLink fieldCode="DE" term="%22Python+programming+language%22">Python programming language</searchLink><br /><searchLink fieldCode="DE" term="%22Database+design%22">Database design</searchLink><br /><searchLink fieldCode="DE" term="%22Learning%22">Learning</searchLink><br /><searchLink fieldCode="DE" term="%22User-centered+system+design%22">User-centered system design</searchLink><br /><searchLink fieldCode="DE" term="%22Autodidacticism%22">Autodidacticism</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: 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]
– Name: AbstractSuppliedCopyright
  Label:
  Group: Ab
  Data: <i>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.</i> (Copyright applies to all Abstracts.)
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=187082225
RecordInfo BibRecord:
  BibEntity:
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 10
        StartPage: 2939
    Subjects:
      – SubjectFull: SQL
        Type: general
      – SubjectFull: Python programming language
        Type: general
      – SubjectFull: Database design
        Type: general
      – SubjectFull: Learning
        Type: general
      – SubjectFull: User-centered system design
        Type: general
      – SubjectFull: Autodidacticism
        Type: general
    Titles:
      – TitleFull: An Implementation of Self-study Exercise Problems for Entry-level SQL-Python Database Programming.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Ni Wayan Wardani
      – PersonEntity:
          Name:
            NameFull: Nobuo Funabiki
      – PersonEntity:
          Name:
            NameFull: Putu Sugiartawan
      – PersonEntity:
          Name:
            NameFull: Pradhana, Anak Agung Surya
      – PersonEntity:
          Name:
            NameFull: Kotama, I. Nyoman Darma
      – PersonEntity:
          Name:
            NameFull: Putra, I. Nyoman Agus Suarya
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 08
              Text: Aug2025
              Type: published
              Y: 2025
          Identifiers:
            – Type: issn-print
              Value: 1816093X
          Numbering:
            – Type: volume
              Value: 33
            – Type: issue
              Value: 8
          Titles:
            – TitleFull: Engineering Letters
              Type: main
ResultId 1