九州地区

教育システム情報学会 2016年度学生研究発表会

Development and Trial Use of a Web-based Database Learning System
Jevri Tri ARDIANSAH*1, Yasuhisa OKAZAKI*2, Aji Prasetya WIBAWA*3, Triyanna WIDIYANINGTYAS*4*1,2
Faculty of Science and Engineering, Saga University, Japan
*1,3,4
Faculty of Engineering, State University of Malang, Indonesia
Email: *1 jev.ardian@gmail.com, *2 okaz@cc.saga-u.ac.jp, *3 aji.prasetya.ft@um.ac.id, *4 triyannaw@gmail.com
Summary：Database is an important part in a system, and it can be accessed by SQL (Structured Query Language).
SQL is a language that used for manipulating data in database. To help beginners to learn about SQL, a system that
can assist them to understand the SQL practical implementation is needed. The system that discussed in this paper isan online system. It provides tasks that should be solved by SQL syntax. To help user, the syntax compiler shows
the message about syntax error, logic error and instruction that should users do. This system prototype is evaluatedby using LORI (Learning Object Review Instrument).
-Key words：SQL, database, logic error, string matching algorithm, Start End Mid Algorithm, prototype, LORI.

1.

Introduction

The first prototype was evaluated by using LORI
(Learning Object Review Instrument) and the result will
be discussed in this article. LORI is a tool for eliciting
ratings and comments from learning resource evaluatorsand its purpose is to support evaluation of multimedia
learning objects (4).

Every system needs a storage media as a data base.
Data base is contained of data which if the data isprocessed will give valuable information (1). The dataprocessing involves a language called SQL. There are
two categories of errors that can occur in SQL statement,
they are syntax error and logic error (2). Different with asyntax error, logic error cannot be detected by SQL
compiler. So, it is needed for further processing to user
SQL statement to know about the logic error. One of theconcepts that can be used to know the logic error iscompare between the user answer with the related
answer key (3).
To help beginners to learn SQL, this system was built
as an online learning and it can be accessed at
http://sqlzone.net. This system’s name is SQLzone as theFigure 1. The lessons in this system is about Selection
concept in SQL as shown as Figure 2.

2.

System Overview

To help users for understanding SQL practically,
SQLzone provides cases which has to be solved using
SQL syntax. Information about the result that wassubmitted by users is also displayed to guide users about
what should they do to solve the case. That information
is about syntax error and logic error that occurred inuser’s SQL syntax. By informing those errors, users areexpected to know the mistakes that they did and makecorrections to solve the related case. The system
overview is shown as the Figure 3.
Syntax error
checking

Logie Error
checking

Suggestion
MakingFigure 3. The system overview
To give an information to user about corrections thatshould they do, system does these process:1. Syntax error checking
After user tried to solve the case with the SQL, in the firstphase, the user SQL statement will be checked by SQL
compiler (5). In this phase, the compiler will inform the syntax
error until the SQL statement is true. Then the table result willbe shown.
2. Logic error checking
In this phase, SQLzone uses Start End Mid algorithm tocheck the similarity between user’s result table with key
answer’s table (6). In this case, if those data are different, itmeans that the user’s SQL has logical error to solve the case.
3. Suggestion making
The last one is about giving a feedback to users about thelocation of keyword that makes logic error in their SQL
statement. This process compares the user’s SQL with the key
answer’s SQL. By gives the different result table, both of
those syntax must be different. Then the system searches thedifferences and gives a suggestion about the user mistakes.

Figure 1. SQLzone

Figure 2. Lessons in SQLzone

233

九州地区

教育システム情報学会 2016年度学生研究発表会

To support the learning process, SQLzone has four
sections as Figure 4. Those sections represent thestandard minimum about effective e-learning media (7).
Those standards are activity, scenario, feedback, delivery,
context, and influence components (8).

In the implementation, each scoring aspect wasdeveloped in to two related questions. Table 2 shows theresult of this evaluation.
Table 2. Questionnaire result
No123456789Figure 4. The learning sections

Concept shows the general description about thechosen SQL keyword lesson. In this section, users canlearn about selected keyword’s basic knowledge. Afterusers possess the basic knowledge, they have to know
the database design. Database design will be shown in
the Scheme section. And the Case section shows thestory and case that should be solved in Compiler section.

3.

4.

System Evaluation

(2)

(3)

Clicked hint button
Feedback

Select * fromcompany
Select * fromdepartement
Select * fromSelect * fromdepartment
Select * fromdepartment
Select * fromdepartment

Select * fromdepartment

Select city
fromdepartment
Select city
fromdepartment
Select city
fromdepartment
Select * fromdepartment

Unknown column company in fieldlist
Table sqlr4324sql_departement does
not exist
You have an error in your SQL
syntax. Check the manual that
corresponds to your MySQL server
version for the right syntax to use atline 1
Logic error occurs near the - * word

Select country
from customer
SelectSelect * from
employee where
dept_id=5…

…

DBtablev

Goaltable-SQL
key-vvv---v--

Logic error occurs near the –COUNTRY CUSTOMER – word---

No table used---logic error occurs near the –EMPLOYEE WHERE DEPT_ID=5– word…

vv

v

…

…

…

Conclusion

References(1)

Table 1. Prototype trial data example
Answer Key

Average Score
4.3
4.4
4.1
4.7
4.3
4.1
3.7
4.6
4.0
4.2

Based on the evaluation, SQLzone still has no bug insuggestion making. But based on questionnaire, thelowest score is on the accessibility (3.7) because thedisplay of compiler page cannot fit in the tablet or phone
access. Based on hint buttons that user used, all of hints
are needed to help user to answer the case if they have noidea. This evaluation was conducted not for all lessons.
Based on that matter, to know about the greater accuracyof system, it is needed to complete the all of the lessons
and let users do all of them.

To know the accuracy of the first prototype, evaluation
was held in 4 days from 7th – 10th February 2017 andthere were 10 male students who tried SQLzone. The
percentage of their SQL ability is 1 advanced student, 7intermediate students, and 2 beginner students. User’s
range age is from 21-24 years old. They accessed
SQLzone by http://sqlzone.net and did the “select” and“select column’s name” tasks. Answer, task’s finishingtime, clicked hints and system feedback were recorded.
Table 1 shows the user’s answer who made mistakes intheir SQL syntax.

User’s SQL

Scoring Aspect
Content quality
Learning goal alignment
Feedback and adaptation
Motivation
Presentation design
Interaction usability
Accessibility
Reusability
Standard compliance
Average

(4)

(5)

(6)

(7)

Based on that data, there is no mistake about thesystem feedback. SQLzone displays feedback in thecorrect way as far. The average of task’s finishing time is139 seconds. And the percentage of clicked hint buttons
is 58% for database table hint, 58% for goal table hint
and 44% for SQL answer hint.
In this evaluation, there was also questionnaire thatgiven to users. That questionnaire was based on LORI. It
uses 9 scoring aspects to evaluate the object. For eachpoint, there is a rating scale from 1 (low) to 5 (high) (4).

(8)

234

Elmasri, Rames & Navathe, Shamkant. “Fundamentals ofDatabase System (6th edition)”. Pearson Education Inc. UnitedStates of America (2011)
Goldberg, Christian. “Do You Know SQL? About Semantic
Errors in Database Queries”. British National Conference onDatabase(2009).
http://dbs.informatik.uni-halle.de/sqllint/tlad09.pdf (12th February 2017)
Dollinger, Robert. “SQL Lightweight Tutoring Module –Semantic Analysis of SQL Queries based on XML Representationand LINQ”. Proceeding of World Conference on Education
Multimedia, Hypermedia & Telecommunications Vol.2010 No.1
pp. 3323-3328 (2010)
Leacock, T.L. and Nesbit, J.C. “A framework for evaluating thequality of multimedia learning resources”. Educational
Technology & Society Vol.10, No.2 pp. 44-59 (2007)
Suriawan, Tofa. “Development of Web-based Database Lesson
Learning Media for 2nd Grade Student in Vocational High School
5 Malang”. Bachelor Thesis of Information and Technology
in Education、State University of Malang (2015)
Ardiansah, Jevri Tri.
Aji Prasetya Wibawa, Triyanna
Widiyaningtyas. “Start End Mid Algorithm Implementation
for Detecting SQL Logical Error”. National Seminar Information
Technology and Multimedia, STMIK AMIKOM Yogyakarta Vol.4,No.1, pp. 3.7-1 – 3.7-6 (2016)
Ardiansah, Jevri Tri, Yasuhisa Okazaki, Aji Prasetya Wibawa,Triyanna Widiyaningtyas. “Developing of a Web-based Database
Learning Support System for Practical Implementation of SQL”.
IEICE (Institute of Electronics, Information and Communication
Engineers) Technical Report Vol. 116, No. 266, pp. 57-62 (2016)
Brown, Andrew R & Bradley D. Voltz. “Elements of Effective
e-Learning Design”. International Review of Research in Openand Distance Learning Vol.6, No.1 (2005) http://www.
irrodl.org/index.php/irrodl/article/view/217/1618 (12th February2017)