SQL: Beauty and the Beast

Ardeleanu, Stefan

doi:10.1007/978-1-4842-2080-1_2

Cited by 1 publication

(1 citation statement)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Just like any other programming language, anecdotal evidence has shown that SQL is hard for students [12,13,14,21]. Even the straightforward, English-like syntax of SQL is misleading [22,23]. Other studies have identified that the burden of remembering SQL keywords and database schemas are often challenging [21,24].…”

Section: Introductionmentioning

confidence: 99%

Synthesis of SQL Queries from South African Local Language Narrations

Obaido¹,

Ade-Ibijola²,

Vadapalli³

2020

Adv. sci. technol. eng. syst. j.

View full text Add to dashboard Cite

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.

show abstract