Idea Transcript
DRIVING SCHOOL STUDENT MANAGEMENT SYSTEM
TENGKU DIYANA BINTI TENGKU IBRAHIM
A thesis submitted in fulfillment of the requirement for the award of the degree of Bachelor of Computer Technology (Software Engineering)
Faculty of Computer system & Software Engineering University College of Engineering & Technology Malaysia
MARCH, 2005
V
ABSTRACT
There are only a few driving schools are operating around Pahang, but the total of the driving school cannot manage the number of customers who want to learn driving that are increasing each year. Most of the school company does not apply any computerized system to manage their business properly. All of the process of registering new student is done in traditional way which is using paper forms. The management of student progress is also written in log book. The ways the company manage their business are too complicated. Worst case comes when there are like a hundred of student to be managed in an hour, while the company Is currently short of -workers to find each customer document to be updated. As a result, a system needs to be developed to replace the current system and enhance the company's performance of management. Driving School Student Management System is proposed to handle this job. The system is developed to handle the process of secured login using Rijndael symmetric encryption algorithm, registering new student, searching a student profile and also searching for student progress to be updated using simple linear sequential search algorithm. The expected result from this system is to get the correct output for each function and system is robust and free of error.
\11
ABSTRAK
Di Pahang terdapat hanya beberapa syarikat sekolah memandu yang sedang beroperasi, tetapijumlah mi tidak mencukupi untuk menampung dan mengurus jumlah para pelajar yang semakin menmgkat setiap tahun. Selam itu, hampir keseluruhan syarikat sekolah memandu tidak mengaplikasikan sistem berkomputer untuk menguruskan peril agaan mereka dengan teratur. Kesemua proses pendaftaran pelajar barn diurus dengan menulis di atas borang kertas. Pengurusan kemajuan pelajarjuga hanya ditulis di dalam buku log. Cara syarikat mi menguruskan pemiagaan mereka adalah terlalu rumit. Keadaan akan menjadi Iebih buruk apabila terdapat beratus-ratus pelajarharus diuruskan dalam masa satu jam, manakala syarikat pula sedang kekurangan tenaga pekerja untuk mencari dokumen bagi setiap pelajar untuk diuruskan. Akhirnya keputusan telah dibuat untuk membina sebuah sistem untuk menggantikan cara lama yang digunakan oleh pihak syarikat dan meningkatkan kualiti perlaksanaan keija. DSSMS disyorkan untuk meilgatasi masalah nil. Sistem mi dibina inenggunakan algoritma pengkriptografian bersimetri Rijndael untuk memastikan keselamatan sistem, rnenguruskan pendaftaran pelajar barn, mencari butir-butirdiri pelajar, dan mencari data terbaru kemajuan pelajar untuk diperbaharui menggunakan algoritma pencarian berurutan secara lurus yang mudah. Sistem mi diharap dapat berfungsi dengan balk dan mengeluarkan output yang betul.
VI'
TABLE OF CONTENTS
CHAPTER
1
2
TITLE
PAGE
TITLE PAGE
1
DECLARATION OF ORIGINALITY AND EXCLUSIVENESS DEDICATION
ii
ACKNOWLEDGEMENT
iv
ABSTRACT
v
ABSTRAK
vi
TABLE OF CONTENTS
vii
LIST OF TABLES
ix
LIST OF FIGURES
x
LIST OF ABBREVIATIONS
xiii
LIST OF APPENDICES
xiv
INTRODUCTION
1
1.1
Introduction
1
1.2
Problem Statement
2
1.2.1
Current System
2
1.2.2
Solutions for Current System
3
1.3
Objectives
3
1.4
Scopes
4
LITERATURE REVIEW
5
2.1
Driving School Management System
5
2.2
Hardware and Software Requirements
6
2.2.1
Hardware
7
2.2.2
Software
7
2.3
The Process Flow of the Current System
8
2.4
The Process Flow of DSSMS
17
vii' 2.5
3
Method Applied 2.5.1 Linear Sequential Search 2.5.2 Symmetric Encryption
METHODOLOGY
3.1
Software Process
3.2 Software Development Process Model 3.2.1 Analysis phase 3.2.2 Design Phase 3.2.3 Development Phase 3.2.4 Testing Phase 3.3 Hardware Specification 3.4 Software Specification 4
5
REFERENCES
Appendices A-C
22 22 23 28 28 29 30 32 47 52 58 58
RESULT AND DISCUSSION
59
4.1 4.2 4.3 4.4
Result and Discussion Assumption
59 60
Constraints
61 61
Further Research
CONCLUSION
63 65 66-78
Ix
LIST OF TABLES
TABLE NO.
TITLE
PAGE
2.1
Hardware Type
7
2.2
Software Type
7
3.1
Hardware Specification
58
3.2
Software Specification
58
x
LIST OF FIGURES
FIGURE NO.
TITLE
PAGE
2.1
Flow of the Current System
9
2.2
Continue of the Flow of the Current System
10
2.3
Continue of the Flow of the Current System
11
2.4
Continue of the Flow of the Current System
12
2.5
Continue of the Flow of the Current System
13
2.6
Continue of the Flow of the Current System
14
2.7
Continue of the Flow of the Current System
15
2.8
Continue of the Flow of the Current System
16
2.9
Flow of DSSMS
18
2.10
Continue of the Flow of DSSMS
19
2.11
Continue of the Flow ofDSSM5
20
2.12
Continue of the Flow of DSSMS
21
2.13
VB. NET code to search the Student Profile by I/C
23
number 2.14
Symmetric encryption / decryption process
23
2.15
The data in the Users.xml file
24
2.16
Users.xm! file after being encrypted
24
2.17
VB.NET code to encrypt the Users.xml file using the Rijndael symmetric encryption algorithm
25
2.18
VB.NET code to encrypt the Users.xml file
26
2.19
VB.NET code to decrypt the Users.xml file
27
3.1
The phases of a problem solving loop
29
3.2
The Incremental Model
30
3.3
D5SM5 Use cases
31
3.4
The Design Model
32
3 •5
Login Form
33
3.6
Register Student interface
34
3.7
Search Profile Interface
35
3.8
Edit Student Profile Interface
36
3.9
Search Progress Interface
37
3.10
Search Result of Student Progress Interface
38
3.11
Simplicity of the Search Profile interface
39
3.12
The Search Profile interface after the correct I/C number
40
is entered 3.13
The supports provided by the system
41
3.14
The obviousness of the purpose of the 'Delete' button
41
3.15
The Search Progress interface
42
3.16
The beginning state of the Search Progress interface
43
3.17
Registering data in Register Student
44
3.18
Search Profile shows the updated data in the database
45
3.19
Choose a date in the calendar in Edit Student Profile
46
interface 3.20
DSSMS Database Design
47
3.21
Login DSSMS code
48
3.22
Register Student code
48
3.23
Search Profile code
49
3.24
View searched student profile code
49
3.25
Edit student profile code
50
3.26
Update the student profile code
51
3.27
Delete the student profile code
51
3.28
Search the existing license class in the LicenseDetails
51
table code 3.29
Update code
52
3.30
Failed login
53
3.31
Third failed login
54
3.32
Wrong phone number entered
55
3.33
Correct data entered
56
3.34
Inputs are properly accepted and output is correctly
57
3•35
Cl C2 C3 C4 C5
C6 C7 C8 C9 CIO Cli
produced Database is properly maintained
57
68
Login form Register Student form Filled form
69 70
Search Profile form Search Profile result Delete Student Profile result Edit Student Profile result
71 72 73 74
Search Progress form Search Progress found
75 76 77 78
Search Progress data is saved Search Progress checkbox is all filled
LIST OF ABBREVIATIONS
Bhd. DSSMS IBM
- - -
Berhad Driving School Student Management System International Business Machines
ID I/C JPJ KM KPP Ms NO OOA PMC Sdn. SQL VB
- -
Identity Identity card Jabatan Pengangkutan Jalan / Road Transport Department Kilometre Kursus Péngajaran Dalam Bilik Darjah/Indoor Teaching Course
- -
- - Microsoft - Number - Object-oriented analysis - Pusat Latihan Memandu Cermat Pahang Timur Sdn. Bhd. - - -
Sendirian Structured Query Language Visual Basic
LIST OF APPENDICES
TITLE
APPENDIX
A
Gantt Chart
B
Questions and Answers
C
User Manual
PAGE We
67 68
CHAPTER 1
INTRODUCTION
1.1
Introduction Nowadays, the process of manual laboring of documentation writing is
considered outdated. Furthermore, this process can cause a lot of trouble especially for a big company that is miming a business and keeping a lot of critical data involving their business safe is crucial. In this case, Pusat Latihan Memandu Cermat Pahang Timur Sdn. Bhd. (PMC) is facing the same problem because all kind of documentations are done in human handwriting. To make matters worst, the company has to manage hundreds of customers' data daily. This company needs to transform the traditional process of written documentation into computer digitalized documentation. This company needs a system that can manage the students' data properly.
As a result, a project of developing a computer application system called Driving School Student Management System (DSSMS) will be built to solve this problem. The request for this system to be developed is made from the client which is Pusat Latihan Memandu Cermat Pahang Timur Sdn. Bhd., a driving school h eadquarters situated at KM 8 Beserah, Kuantan Pahang. PMC is the main office of all driving schools in Kuantan, The company teach the students from all around east Of Pahang of how to learn to drive and the process steps for a student to go through to get a driving license. This company runs the business of managing students' data in volving their driving lesson to get a driving license. Some of the data also has a Connection with the Road and Transport Department (JPJ). The PMC customers will
be known in this document as students. The users for the system will be the staffs' of PMC. The student will go through the process of getting a license including registering for courses and test.
DSSMS will replace the traditional system used by PMC which is all hand written documents. All data will only be keyed in by the office staff ofPMC. DSSMS will keep all records of data of the student registration and progress digitally. It will also remind any failed test by student to be repeated. As a summary, this system let the company to keep their data safely in a digital type of memory copy plus, the management of data is more systematic than the traditional process.
1.2 Problem Statement 1.2.1 Current System At this time, the process of the current system is all done in documentation of papers and log book. Then this document will be kept in a folder. Next, the folder is saved in a rack room. This cost the client to provide a lot space to save thousands of documents and folders. Besides costing space, the process also wastes a lot papers. Every process of students' learning progress and students profile details are all handwritten down by the office clerks making the process slow and the data security is not reliable because the paper document can easily get lost This process will waste lots of energy and human workforces to write down everything.
Furthermore, the management of data in this current system is too complicated, and poorly done. For example, if a student has a change of their home address, the PMC staff is incapable of updating the document of a student profile. Keeping the data in an unsecured room can let any unauthorized person to access it. Critical data might be changed or worse deleted by an irresponsible individual. In this case, that individual may want to take advantage of making illegal license that can relate with the company integrity. Improperly managed files will make the
J
matters worse for the staffs to search for a certain students profile and keeping track of their learning progress.
1.2.2 Solutions for Current System (i)
The Driving School Student Management System is more secured because there will only be one user, which is the PMC staff who can use this system to key in any data. This method can help to reduce a lot of energy and workforce.
(ii)
The system is also protected by user login ID and password to restrict unauthorized access.
(iii)
All data is keyed in the system and save in the database for later use rather than writing and keeping the document in a rack to make sure that the data is more safely secured.
(iv)
Data is safely kept -ina softcopyand backup copies rather than hardcopies to safe a lot of documents and folders room space and also to reduce papers usage.
(v)
Management, updates and keeping track of data is easily done in just clicking some buttons to get the specific data, for example to search for student progress will only need the staff to type the student I/C number and click search.
1.3
Objectives
(i)
To create a standalone system that let the user to manage and manipulate data through adding, updating and deleting data of student profile.
(ii)
To create a relieving way for the staff to do searching using simple linear sequential search algorithm.
4 1.4
Scopes
(i) (ii)
DSSMS is only for PMC staff as the administrator used only. Student Registration will include the process of registering the students with the driving school and also manipulating the student profile data through edit, update and delete.
(iii)
Search for a specific student profile and student progress based on the student's I/C number.
(iv)
The system only manages the students that apply for motorcar or motorcycle licenses.
(v) (vi)
Student progress can accept payment by task only. The system will manipulate data that is from PMC only.
CHAPTER 2
LITERATURE REVIEW
2.1 Driving School Management System The system is called Driving School Student Management System because the system will be used by a driving school staff which is Pusat Memandu Cermat staff to manage the data about the students whom register with the driving school to get a driving license. The system will be used based on the management of students' data during the application of driving license in the driving school. The system will be a standalone system because it can only be used by the PMC staff to manage data, it resides on its local disk and it can be managed through back end only. The system does not connect to the internet and or any other organization.
Driving School Student Management System provide services for Pusat Memandu Cermat staff such as registering new students who want to learn to drive and apply for driving license with the driving school. The system can process a total of maximum 300 students per week. DSSMS is the first and only student management system that is available in Pahang area because others company are still doing the traditional method.
The staff can enter the data of students' background details in the Student Profile. The system can also search for a ecP2m Student Profile for any updates or delete p rocess. The search method used for this function is the simple linear sequential search
algorithm. "This search method proceeds from the first element, to the second, and so on, visiting each element in turn until the desired element is found or all elements have been checked [1]." The keyword for the staff to enter is the students' JJC number and then click search button to find the data. Besides that, it can search for a certain Student Progress to be updated according to the flow level of the students' driving performance. For example, a student has to pass their computer static test before they proceed to hands-on practice which is the driving lesson. The system will show the status of the past performance of the student. If the student has passed the test, then the staff will update the new status of student performance in the Student Progress. Furthermore, the system will not let the staff to exceed to the next level until the past level is completed.
The system is built to reduce the weakness of the current system used by the PMC Company. The benefits it offers to the company are cutting the cost of human workforce, papers and room space. Besides, it also saves a lot of energy for the staff to find a student profile or a student progress just by entering the students' PC Number and click search button. The process of updating data is also available compare to the traditional current system. The data that is kept in this system is more secured because the system is restricted to only one staff to use at a time. Moreover, the access to the data is restricted by an authentic user ID and password to login to avoid trespassers.
2.2 Hardware and Software Requirements
The client has agreed that the system will be built using Microsoft Visual Studio .NET 2003 software and the programming code is in Visual Basic .NET. Visual Basic NET is a major component of Microsoft Visual Studio .NET. The database for DSSMS will be Microsoft SQL Server that comes along with the software package. DSSMS will be on Windows XP Professional 2003 platform. The software is chosen because DSSMS is a standalone system that suits best with this software. The software also provides Microsoft standard interface that interest the client and it is user friendly. Moreover, the
system can be implemented in object-oriented concept that can assure a lot of benefits at the management and technical level such as faster software development and higher quality program. The data management system will include driving courses, student registration, student progress, test status and etc. The system will only need a computer cpu, monitor, keyboard and printer. The hardware is used for monitoring data, key in data, and printing.
2.2.1 Hardware Table 2.1 : Hardware Type
Item
Description
Number of Item
Desktop
Acer Aspire G600P
1
Printer
Epson Stylus C41IJX Color Printer
2.2.2 Software
Table 2.2: Software Type
Tools
Description
Operating System
Microsoft Windows XP Professional Edition
Development
Microsoft Visual Studio .NET 2003
Database Management
Microsoft SQL Server 2000
Documentation
Microsoft Office XP Professional Edition
Analysis and Design
Rational Rose Enterprise Edition
The cost for the client to prepare the hardware and its operating system is around RM3 188.00. The development of DSSMS will takes 30 days starts from 27 December 2004 and finish until 4 February 2005. The estimation for the full system plus the
documentatio n of this thesis and user manual to be completed and delivered is within 80 days. The final product will be delivered on 28 March 2005. Please refer to Gantt chart in Appendix A to view the full plan of DSSMS project.
2.3 The Process Flow of the Current System
As mentioned before, the management of all students' data at PMC is done in handwriting. This process will waste a lot of the clients' time to manage each of the students. The followings are the process flow of the current system done in PMC that will explain each step the student has to go through to get a driving license:
Begin
J
[Register with PMC
e PMC's student ICNumber, e, Address, eofBirth, _Numberand rPhon ense_Type
AgeCurrent—Year-DOB—Year =
IF License _Type = B and Age