Android Application Development: Basic SQL E-Learning

Abstract

This study describes the steps taken to design and develop Basic SQL E –Learning Application for DEC40073 Database System. Basic SQL E-Learning application is an Android application based that is build using Android Studio which suitable for android devices. This application allows students directly learn MYSQL using their own android smartphone. The main objective is to develop a mobile learning application that provides notes and exercise using MYSQL that can improve focusing and motivation among engineering’s students. The students can perform exercise that divided into two topics, which are Data Definition Language (DDL) and Data Manipulation Language (DML), which contain in a syllabus. The Methodology use to build this application is using ADDIE model that involves five phases (Analysis, Design, Development, Implement and Evaluation). The student will be able to test their knowledge in SQL Queries by using basic operations like Create, Insert, Update, Delete, Select statement and provided with mark at the end of exercise. Upon demonstration, students indicated the positive response and interested to answer the entire question in the exercise provided. Hence, this study discussed the designing and developing of Basic SQL E-Learning on polytechnic students in learning Database System. In the future, this application can be upgrade with music while answering the quiz and compatible with other platforms.