Synthesis of SQL queries from South African local language narrations

Research output: Contribution to journalArticlepeer-review

Abstract

English remains the language of choice for database courses and widely used for instruction in nearly all South African universities, and also in many other countries. Novice programmers of native origins are mostly taught Structured Query Language (SQL) through English as the medium of instruction. Consequently, this creates a myriad of problems in understanding the syntax of SQL as most native learners are not too proficient in English. This could affect a learner’s ability in comprehending SQL syntaxes. To resolve this problem, this work proposes a tool called local language narrations to SQL (Local-Nar-SQL) that uses a type of Finite Machine, such as a Jumping Finite Automaton to translate local language narratives into SQL queries. Further, the generated query extracts information from a sample database and presents an output to the learner. This paper is an extension of work originally presented in a previous study in this field. A survey involving 145 participants concluded that the majority found Local-Nar-SQL to be helpful in understanding SQL queries from local languages. If the proposed tool is used as a learning aid, native learners will find it easier to work with SQL, which will eliminate many of the barriers faced with English proficiencies in programming pedagogies.

Original languageEnglish
Pages (from-to)1189-1195
Number of pages7
JournalAdvances in Science, Technology and Engineering Systems
Volume5
Issue number5
DOIs
Publication statusPublished - 2020

Keywords

  • Language translation Synthesis of things JFA applications SQL queries

ASJC Scopus subject areas

  • Engineering (miscellaneous)
  • Physics and Astronomy (miscellaneous)
  • Management of Technology and Innovation

Fingerprint

Dive into the research topics of 'Synthesis of SQL queries from South African local language narrations'. Together they form a unique fingerprint.

Cite this