Research Article
a
October
2018
Computer Science and Software Engineering
ISSN: 2277-128X (Volume-8, Issue-10)
Android Based Real-time Updatable Routine Management
System
Md. Ismail Husain*, Shake Fahidur Rahman, Md. Harun. or. Rashid and Md. Sofiqul Islam
Department of Information and Communication Engineering, University of Rajshahi, Rajshahi-6205, Bangladesh
[email protected]*, [email protected], [email protected], [email protected]
Abstract— Now we are in the 21st century, era of digitalization. We can access the world through internet within few seconds. In this time, we should participate on digitalization. We observed in our country many educational institutions follow the traditional system to publish a class schedule, but it’s time to make it digital. In this proposed system we developed routine management system which is an android based mobile application of department of Information and Communication Engineering, University of Rajshahi, Bangladesh. This system is used to create and maintenance the class routine of this educational institution. This system provides class schedule to the user for specific day and batch. The primary purpose of developing a mobile application is to have an instant access to the routine from anywhere. Mobile phone is easy to handle and easy to carry for the users. The mobile application is primarily able to view the routine as per requirement of the student.
Keywords— Android application, Digitalization, Routine management system, Database system, Online services.
I. INTRODUCTION
In this world of growing technologies Mobile applications are a rapidly growing segment of the global mobile market. Android was made publicly available during the fall of 2008 [1]. Android provide a suitable architecture for real-time embedded systems. In banking system, we use online transaction as an alternative of traditional system. We use a small android app to complete a money transaction process from anywhere. Now days we no need to go bus counter to book a ticket, we use online app to book a ticket from anywhere. The time of versatile innovation opens the window to the android application. The website is vanishing and the mobile phone is emerging. It’s time to change from conventional class routine to apps, which has become the part of our daily routine. Most educational institutions manually create their routines by using a human resource to work on it. Some institutions create such management system for their personal requirement and use only while others do it manually in this proposed system we would going to create an android application for daily routine management which would consist the real time app to server record updating feature, means all the data is received directly through app from MySQL database online server.
The previous routine system is somehow clumsy and sometimes it is difficult to understand to find out the specific classes in that specific day. If it is necessary to change any of the class schedules, then the total routine should be rearranged and it is also necessary to supply the new rearranged routine in the form of hard copy to the students. We observed traditional routine system and their users, then we get some feedbacks from users which are, it is time consuming, loss of money and sometimes it creates misunderstanding among the students. For this reason, students suddenly miss the class. So, it is sometimes inconvenient to access the main perspective of the routine. So, I think about it and try to make a convenient way to bring out.
We are introducing “Smart Routine.apk” the android application software which would be a convenient form of our class routine, it can work as small routine management software. This software also provides many types of useful link about Different types of activities of the department. Such as programming club, association, department website etc. this project gives a total solution to every student. This application becomes a mobile version of our official routine, it gives us more comfort and a better user interface. This application substance can without much of a stretch refreshed by a manager. In the wake of refreshing all clients get refreshes naturally.
Routine Management System benefits all the educational institutions that currently use manual creation and maintenance of the class routines. Users can easily create and maintain class routines using the system’s simple user interface. It also resolves the issue of manual staffing process into a controlled and closely monitored system. It can be used by every educational institution interested to create class routines using an android system.
ISSN(E): 2277-128X, ISSN(P): 2277-6451, pp. 50-56
II. LITERATUREREVIEW
There are many research fields have been developed based on online android application. Such as health care system, educational system, employee management system, banking system and business management system. The services of mobile pervasive healthcare technologies including mobile telemedicine, patient monitoring, location-based medical services, emergency response and management, personalized monitoring and pervasive access to healthcare information, providing great benefits to both patients and medical personnel [2].
Now many developed country educational system become online based. Android based Learning Management System(LMS) that helps students to interactively learn a new course. LMS provides C, C++, JAVA, ASP.NET, HTML, CSS, Java Script, Python, and aptitude test, personality development and skill development related training for the betterment of future of student by providing them study material and video lectures [3]. In [4] developed student attendance system. It has provided a convenient method of attendance marking compared to traditional method of attendance system. In addition, it is user friendly system as data manipulation and retrieval can be done via user interface, making it universal attendance system and adaptive for implement in any educational system.
Online digital management system is very important in our education system. The real time updatable routine management system is required in digital education. So we proposed a routine management system, that help in the education system to digitalize.
III. SYSTEM DESIGN
A. Design Tools
Routine Management System follows two-tier architecture for the client request and server response operations. It is a combination of web server including database and mobile application. Hence the web server is accessed using a browser via internet connection to modify existing database. User can view the routine using android app. An admin can update the routine as per requirement. The following tools are used to design the overall system.
Android studio(java): Android Studio was used to develop the mobile application of Routine Management System. It was used to develop both front end and backend side of the mobile application. All functionalities are developed by java programming language.
PHP: It used to operate database which is store in online server.
PHP my admin: We use this tool to store data into database and manages database. We also use it to store PHP
file.
DBMS: We use MYSQL as a database management system. Which is store in online server and we use000webhosting for free as an online server to store and retrieve data.
B. Data Collection
Data for Routine Management System was collected by taking class routine of Information and Communication Engineering department, University of Rajshahi, Bangladesh. Fig. 1 shows the traditional routine management system in our country. This type of routine management system is complex to update any parts.
ISSN(E): 2277-128X, ISSN(P): 2277-6451, pp. 50-56 C. Database System Design
After the collection of data, we design the database for more efficiently manage the traditional routine management system.
The routine data are stored in the online database server. We use PHP file to retrieve data from database. The routine data are also retrieved from the same files. PHP files makes the required data as JSON format and android app display those data by HTTP call and HTTP request.
We use SQL to operate query into our database. We use 000webhost.com to store our data, which is online activated and we use MySQL database as a remote server. Input data of routine management system is sequentially and day specifically. To manage our database, we used PhpMyAdmin panel.
Fig. 2 PhpMyAdmin panel.
We use our android app user interface to retrieve data from database server as per user requirement.
Fig. 3 State diagram of mobile application.
In Fig. 3 shows the state diagram of the mobile application of Routine Management System. Here the user first opens the mobile application. Then choose his/her desire year/semester to get class schedule for specific day. During that time at back end data retrieve from online database as JSON format and then app convert this to sampler form and display to the user.
D. Admin Role to Maintain this System
ISSN(E): 2277-128X, ISSN(P): 2277-6451, pp. 50-56
PhpMyAdmin through web and store data into database server which is online remote server. User can get real-time update automatically at user interface.
An admin should collect data from traditional routine and insert data sequentially into online database server. Firstly, an admin should log in https://www.000webhost.com/cpanel-login to manipulate data, this link also attached into our developed app. when admin insert all data once then no need to change all data for specific editing. Only admin can change the database by providing his/her username and password.
Fig. 4 Diagram of database management.
IV. IMPLEMENTATION AND RESULT
Each activity of android window represents different operational process of implemented routine management system. Here we represent some snapshot of implemented routine management system with explanation. In Fig 5(a) shows the app icon with the name of “Smart Routine”. User should touch the app icon to run the android app.
(
a
)(b)
Fig. 5 (a) Android app icon home page. (b) Year selection activity.
ISSN(E): 2277-128X, ISSN(P): 2277-6451, pp. 50-56
After taping the year-based activity button (odd/even) next activity will appear as shows in Fig. 6(b) where user see different day within a scrollable list view. Note that, our designed routine management system for University of Rajshahi has weekly two off days, so total weekly five working days.
(
a
)(b)
Fig. 6 (a) Year based activity. (b) Day selection activity.
If users choose any day for specific class schedule then next activity as shows in Fig. 7(a) and 7(b) will appear with class time, course and corresponding teacher’s name. Here in figure 7(a) represents loading data from online database server.
(
a
)(b)
ISSN(E): 2277-128X, ISSN(P): 2277-6451, pp. 50-56
In designed app has some useful links are attached in navigation drawer as shows in Fig. 8(a). It is a scrollable list view. User can access to the link via internet browser. Users can view their academic syllabus according to their session as shows in Fig. 8(b). It is a clickable list view, if user tap on their desire session next activity will come with course code, course name and corresponding credits as shows in Fig. 8(c).
(
a
) (b) (c)Fig. 8 (a) Useful link activity. (b) Session selection activity. (c) Syllabus of first year odd semester activity.
V. CONCLUSIONANDFUTUREWORKS
Real time routine management system based on android application is useful for any educational institution. We want to create an efficient way to make the routine management system faster than traditional routine management system. We designed this android application for department of information and communication engineering, university of Rajshahi. It is also implementable for any educational institution. It helps both teacher and student to find their class schedule in one click.
Future works will be focused on enhancing the performance of this system to make it more efficient and autonomous. Data can insert through user interface to update the database.
REFERENCES
[1] (2017) The Android website. [Online]. Available: http://www.android.com
[2] Charalampos Doukas, Thomas Pliakas and Ilias Maglogiannis, “Mobile Healthcare Information Management
Utilizing Cloud Computing and Android OS,” in 32nd Annual International Conference of the IEEE EMBS, 2010, p. 1037-1040.
[3] Netrapal Singh Rana, Nupur Jain, Nishank Agarwal, Mohit Kumar Bordia and Nisha Jain “A Virtual Android
based Learning Management System for Developing Smart Cities” in IJSTE, National Conference on Road
Map for Smart Cities of Rajasthan (NC-RMSCR), April 2017, p. 326-330.
[4] Mohammed A. Jabbar Hameed “Android – based Smart Student Attendance System” International
Research Journal of Engineering and Technology (IRJET), Volume: 04, Issue: 12, pp. 1669-1673,
Dec-2017.
[5] Shweta Shashikant Tanpure, Priyanka R. Shidankar and Madhura M. Joshi “Automated Food Ordering System
with Real-Time Customer Feedback” International Journal of Advanced Research in Computer Science and
Software Engineering (IJARCSSE), Volume 3, Issue 2, pp. 220-225, February 2013.
[6] (2017) Android activity manager on Android. [Online]. Available: https://developer.android.com/reference/
ISSN(E): 2277-128X, ISSN(P): 2277-6451, pp. 50-56
[7] (2017) The w3schools website. [Online]. Available: https://www.w3schools.com/sql
[8] A.J. Kadam, Aradhana Singh, Komal Jagtap and Srujana Tankala “Mobile Web Based Android Application for
College Management Sysytem” International Journal of Engineering and Computer Science, Volume 6 Issue 2,
Page No. 20206-20209, Feb. 2017.
[9] Mweemba Simaanya “Employee management system,” B.Sc. thesis, University of Zambia school of natural