taman tasik utama 3 utem hostel registration system...
TRANSCRIPT
TAMAN TASIK UTAMA 3 UTeM HOSTEL REGISTRATION SYSTEM
(TRRS)
NOR DIANA BINTI ISMAIL
(8030710116)
FACULTY OF INFORMATION AND COMMUN ICATION TECHNOLOGY UNIVERSITI TEKNIKAL MALAYSIA MELAKA
BORANG PENGESAHAN STATUS TESIS*
JUDVL: __ -'T'"'a"'m,.,a"-'o ........ T=-a'"'si=-k-'U""t"'a"'m""a!..:3~U'-'TC>e:!.!M~H.,os=te"'-I.:.R",eg"",-,is:!.trao=t",io",o",S",y",s",te",-m,,, __ _
SESI PENGAJIAN: ______ -=2".,OO""9.:..:I2"'O-'-'tO"-_______ _
Saya ___ --'N"'"O=R-'D'""IAN=-'-"A~B""1N_'_T.!..:I'_'I"'S":'M'-!A::'I ... L~~~_:__-------(HURUF BESAR)
mengaku membenarkan tesis (PSMISarjanalDolctor Falsafah) ini disimpan d i Perpustakaan Fakulti Teknologi Maklumat dan Komunikasi dengan syarat-syarat kegunaan seperti berikut:
I. Tesis adalah hakmilik Universiti Teknikal Malaysia Melaka 2. Perpustakaan Fakulti Teknologi Maklumat dan Komunikasi dibenarkan
membuat salinan untuk tujuan pengajian sahaja 3. Perpustakaan Fakulti Teknologi Maklumat dan Komunikasi dibenarkan
membuat salinan tesis ini sebagai bahan pertukaran antara institusi pengajian tinggi.
4. •• Sila tandakan (f)
SULIT
TERHAD
/ TIDAK TERHAD
(T ANDA T ANGAN PENULlS)
Alamat tetap: No.27, Jalan Baru, Kampung Pak Dollah, 34600 Kamunting, Perak
Tarikh: _--'-).....:q.!..(;..J6!'-)=-D.;..''' ____ _
(Mengandungi maklumat yang berdarjah keselamatan atau kepentingan Malaysia seperti yang termaktub di dalam AKTA RAHSIA RASMl 1972)
(Mengandungi maklumat TERHAD yang telah ditentukan oleh organisasil badan di mana penyelidikan dijalankan)
(TANDATANGAN PENYELlA)
PUAN ZARIT A BINT MOHD KOSNIN Nama Penyelia
'J.. a /0 .(; !'L() I 0 Tarikh : ___ I ____ _
CATATAN: * Tesis dimaksudkan sebagai Laporan Akhir Projek Sarjana Muda (PSM) ** Jika tesis ini SULIT atau TERHAD, sila lampirkan surat daripada pihak berkuasa.
TAMAN TASIK UTAMA 3 UTeM HOSTEL REGISTRATION SYSTEM
(THRS)
NOR DIANA BINT! ISMAIL
This report is submitted is partial fulfillment of the requirements for the Bachelor of Computer Science (Software Development)
FACULTY OF INFORMATION AND COMMUNICATION TECHNOLOGY UN IVERS ITI TEKNIKAL MALA YSIA MELAKA
20 10
DECLARATION
I hereby declare that this project report entitled
TAMAN TASIK UTAMA 3 UTeM HOSTEL REGISTRATION SYSTEM
is written by me and is my own effort and that no part has been plagiarized
without citations.
STUDENT
1\
(NOR DIANA BINTI ISMAIL)
SUPERVISOR: W Date: ?--'1 [ Of. I ~ l ()
(pUAN ZARITA BINT MOHO KOSNIN)
III
DEDICATION
To Almighty, ALLAH S.W.T
To my greatest idol , Rasulullah SA W
To my beloved parents, Ismail Bin Shafie, Saadiah Binti Hashim and my family
To my kind supervisor, Puan Zarita Binti Mohd Kosnin
To my kind assessor, Madam Kasturi Kanchymalay
To all my friends
iv
ACKNOWLEDGEMENTS
First for all, I would like to take this opportunity to show my gratitude to the
person who had helped, supported and guided me throughout the completion of Projek
Sarjana Muda.
Especially thanks to my supervisor, Puan Zarita Mohd Kosnin, for your support
and supervision that was given to me. Without you commitment, I would have been lost
and cannot complete my project successfully. Besides that, your advise are very usefu l
in PSM and thank you very much for your time despite the busy schedule and others
commitment.
Then, my extended thank you goes to Universili Teknikal Malaysia Melaka
(UTeM) for creating an opportunity for all final year students to carry out their final year
project. With this final year project, I can apply all the knowledge learned in UTeM
from first year until now. My most grateful thanks to my family members who gave me
lots of support and motivation throughout completing my project.
Last but certainly not the least, I would like to thank the reader for taking your
time to read this report.
v
ABSTRACT
Telephone is one tool that is needed and very useful for communication. The system that has been developed is a registration system for Taman Tasik Utama 3 UTeM Hostel. It is called Taman Tasik Utama 3's UTeM Hostel Registration System (THRS). THRS is one hostel registration system, which provides notification through mobile application. This application use GSM Modem or telephone as modem to communicate with the database, server and web system. THRS offer great potential and benefit for users which it easy to use and very fast in order to communicate which each other.
VI
ABSTRAK
Telefone bimbit merupakan alat yang menjadi keperluan semasa dan amat berguna untuk berhubung. Sistem yang dibangunkan adalah sistem pendaftaran untuk kolej kediaman untuk Taman Tasik Utama 3 UTeM kolej kediaman yang dipanggil Taman Tasik Utama 3 UTeM Hostel Registration System (THRS). THRS adalah satu sistem pendaftaran asrama yang menggunakan aplikasi-mudah alih di dalam modul sebagai pemberitahuan. Aplikasi ini menggunakan GSM modem atau telefon bimbit sebagai modem untuk menghubungkan THRS dengan pangkalan data, server dan sistem web. THRS menawarkan potensi yang besar dan kelebihan kepada pengguna telefon bimbit di mana ianya mudah dan pantas untuk berhubung.
vii
TABLE OF CONTENTS
CHAPTER SUBJECT PAGE
DECLARATION ii
DEDICATION iii
ACKNOWLEDGEMENTS iv
ABSTRACT v
ABSTRAK vi
TABLE OF CONTENTS vii
LIST OF TABLES xi
LIST OF FIGURES xiv
LIST OF ABBREVIATIONS xvi
LIST OF APPENDICES xvii
CHAPTER I INTRODUCTION
1.1 Project Background
1.2 Problem Statement(s) 2 1.3 Objectives 3
1.4 Scope 4
1.5 Project Significance 5
1.6 Expected Output 5
1.7 Conclusion 6
VIII
CHAPTER SUBJECT PAGE
CHAPTER II LITERATURE REVIEW AND
PROJECT METROLODY
2. I Introduction 7
2.2 Facts and Findings 7
2.2.1 Domain 8
2.2.2 Existing System 8
2.2.3 Technique 12
2.3 Project Methodology 13
2.4 Project Requirements 15
2.4.1 Software Requirement 16
2.4.2 Hardware Requirement 17
2.4.3 Other Requirement 18
2.5 Project Schedule and Milestones 18
2.6 Conclusion 19
CRAPTERUI ANALYSIS
3.1 Introduction 20
3.2 Problem Analysis 20
3.3 Requirement Analysis 22
3.3.1 Data Requirement 22
3.3.2 Functional Requirement 23
3.3.3 Non-functional Requirement 26
3.3.4 Others Requirement 27
3.4 Conclusion 30
ix
CHAPTER SUBJECT PAGE
CHAPTER IV DESIGN
4.1 Introduction 31
4.2 High-Level Design 32
4.2.1 System Arch itecture 32
4.2.2 User Interface Design 33
4.2.2.1 Navigation
Design 34
4.2.2.2 Input Design 36
4.2.2.3 Output
Design 38
4.2.3 Database design 43
4.2.3.1 Conceptual
And Logical Database 43
4.3 Detailed Design
4.3.1 Software Design 46
4.3.2 Physical Database Design 48
4.4 Conclusion 48
CHAPTER V IMPLEMENT A nON
5.1 Introduction 50
5.2 Software Development Environment Setup 51
5.3 Software Configuration Management 51
5.3.1 Configuration Environment Setup 52
5.3.2 Version Control Procedure 53
5.4 Implementation Status 54
5.5 Conclusion 55
CHAPTER
CHAPTER VI
CHAPTERVll
SUBJECT
TESTING
6.1 Introduction
6.2 Test Plan
6.2.1 Test Organization
6.2.2 Test Environment
6.2.3 Test Schedule
6.3 Test Strategy
6.3.1 Classes of tests
6.4 Test Design
6.4.1 Test Description
6.4.2 Test Data
6.5 Test Result and Analysis
6.6 Conclusion
PROJECT CONCLUSION
7.1
7.2
7.3
7.4
Observation on Weaknesses and Strengths
Proposition for Improvement
Contribution
Conclusion
REFERENCES
BmLIOGRAPHY
APPENDICES
PAGE
56
57
58
58
59
60
61
63
63
82
105
105
106
108
108
109
110
111
113
x
XI
LIST OF TABLES
TABLE TITLE PAGE
2.1 Comparison Existing System 12
2.2 Project Schedule and Milestones 18
3.1 Non-Functional Requirement for THRS 26
4.1 Table session 61
4.2 Table employee 61
4.3 Table login_employee 61
4.4 Table student 61
4.5 Table login_student 62
4.6 Table hostel 62
4.7 Table block 63
4.8 Table house 63
4.9 Table room 63
4.10 Table year_student 64
4.11 Table selected student 64
4.12 Table faculty 65
4.13 Table applicationJorm 65
4.14 Table msgin 66
XII
TABLE TITLE PAGE
4.15 Table notification 67
5.1 Dataset Used for Version Library 53
5.2 List of Procedure and control 54
5.3 Implementation Status 55
6.1 Test Organization 57
6.2 Test Environments 58
6.3 Test Schedule 59
6.4 Black Box Testing and White Box Testing Test Classes 61
6.5 Login 64
6.6 Manage Hostel 65
6.7 Manage Block 66
6.8 Compulsory Student 68
6.9 Manage Apply Student 78
6.10 Manage Notification 79
6.11 Manage Registration 79
6.1 2 Manage Change Password 80
6.13 Apply Appeal Hostel 81
6.14 Register Room 81
6.15 Test Data Login 82
6.16 Test Data Manage Hostel 82
6.17 Test Data Manage Block 84
6.18 Test Data Compulsory Student 88
xiii
TABLE TITLE PAGE
6.19 Test Data Manage Apply Student 101
6.20 Test Data Manage Notification 101
6.21 Test Data Manage Registration 102
6.22 Test Data Manage Change Password 103
6.23 Test Data Apply Appeal Hostel 104
6.24 Test Data Register Room 104
xiv
LIST OF FIGURE
FIGURE TITLE PAGE
2.1 UKM Hostel Application fonn for Apply Student Webpage 10
2.2 UKM Hostel Login Webpage II
2.3 UKM Hostel Main Menu Webpage II
2.4 Throwaway Development Methodology 15
3.1 Data Flow Diagram for Current System 21
3.2 Context Diagram ofTHRS 24
3.3 Data Flow Diagram Level 0 for THRS 25
4.1 Three-Tier THRS Architecture 33
4.2 THRS Navigation Design 35
4.3 THRS Web Design Page 36
4.4 THRS Admin/Officer Menu Web Page 37
4.5 THRS Student Menu Web Page 38
4.6 THRS Success Login page 39
4.7 THRS Success Save Hostel page 39
4.8 THRS Success Update Hostel page 39
4.9 THRS Success Save Block page 39
4.10 THRS Success Update Block page 40
4.11 THRS Success Delete Block page 40
xv
4. 12 THRS Success Save New List Student page 40
4.13 THRS Success Update New List Student page 40
4.14 THRS Success Allocate Student page 41
4.15 THRS Success Save Selected Student page 41
4.16 THRS Success Send Notification by Mobile page 41
4.17 THRS Success Save Accept Key page 41
4.18 THRS Success Save Return Key page 42
4.19 THRS Success Save New Account page 42
4.20 THRS Success Save Application Form page 42
4.21 THRS Success Save Registration Room page 42
4.22 ERDs for THRS 45
5.1 Software Environment Setup 51
THRS
PSM
UTeM
UKM
SSADM
SDLC
DFD
PHP
ERD
CSS
SMS
PK
FK
SQL
DDL
LIST OF ABBREVlA TlONS
Taman Tasik Utama 3' s UTeM Hostel Registration System
Projek Sarjana Muda
Universiti Teknikal Malaysia Melaka
Universiti Kebangsaan Malaysia
Structured System Analysis Design Methodolgy
System Development Life Cycle
Data Flow Diagram
Hypertext Processor
Entity Relationship Diagram
Cascade Style Sheet
Short Message Service
Primary Key
Foreign Key
Structured Query Language
Data Definition Language
xvi
xvii
LIST OF APPENDICES
APPENDIX TITLE PAGE
A Data Dictionary THRS 113
B Data Flow Diagram Level I and 2 122
C Input Design THRS 129
D Normalization 156
E Data Definitions Language 160
F Test Result and Analysis 166
G Grantt Chart 214
H User Manual 216
6
manage student by categorized compulosry student and apply student. Allocation student
is begin with choose total student each faculty and system will choose selected students
based on what officer chooses. For apply student, there have function that available for
officer to accept or reject student for appeal hostel. Besides that, officer can manage
notification that will send to student either to compulosry student or apply student. Also,
there have function which manage registration day which give room key to student
which already register room using system and return room key in end of semester.
1.7 Conclusion
As a result, Chapter I briefly describe the introduction information of THRS
problem statement, project objective, scope, project significance, and expected output. It
is important to clearly list out all the important point needed to develop a system before
could start developing the system.
The next chapter will explain on literature review and project methodology,
which will be applied in developing the system.
5
1.5 Project Significance
UTeM hostel management not have specific system for registration room for
student. This opportunity for student to register room using web based after Sistem
Maklumat Pelajar (SMP) and Print system apply in daily life of student in order for
smooth operation without need more worker and this application reduce time.
The student of UTeM have notification by mobile need register to TTU3 hostel
can use this system to register for available room before their start new semester. This
more faster and less cost rather come to hostel for registration.
In addition, the student UTeM whom like student year 3 or year 4 can apply to
appeal hostel if there enough available room or officer can determine either selected
student can appeal hostel or not based on several criteria. The management of student for
registration hostel is become easier to manage rather depend to the manual registration
with existing system.
1.6 Expected Output
This web-based and mobile application will have registration room function
which allow selected year I and year 2 and who was success appeal of hostel (year 3 or
4) UTeM's students to register a room which available to them. Then, system have
function which allow student year 3 or 4 to apply appeal of hostel by submit their
application form. The notification by mobile will send to student for information about
registration details. Also, the notification for status for appeal of hostel is send through
by mobile.
In addition, there have function for officer of hostel to manage hostel by manage
block, house and room that available for accommodation student. In addition, officer can
4
empty room and apply appeal hostel by submit application form and also get
their status from thi s system. Then, the officer can choose apply appeal using
this system and the system will send status notification through mobile.
• Help student gets early and prompt notification about hostel registration
and appeal hostel application status
1.4 Scope
Officer can manage notification and send notification thorugh mobile
to selected student either compulsory student or apply student. The selected
student will get Short Mssage Service (SMS) from system. For apply student,
they will get their status about appeal hostel either success or failed.
TTU3 UTeM's Hostel Registration system is a web based and mobile application
system. The users of this system are of three categories:
• Officer ofTTU3 UTeM hostel
• Student Year I and Year 2 of UTeM who are selected to register room at
TTU3 UTeM's hostel
• Student of UTeM in Year 3 or Year 4 who wants to appeal TTU3 UTeM
hostel
This system only use for registration room for TTU3 UTeM's hostel only. This system
can use if there internet connection for access by user. The GSM modem or handphone
as modem connection is needed for accessing by system. The system which use Window
XP 2003 and GSM modem or Handphone modem as plaftorm for this system.
3
calling them and give feedback for their form wether their appeal is success or
failed. The confirmation know within two or a week before a new semester
begin. J f student failed, this making a huge trouble to them because their need
search a room for rent in short time before the new semester begin.
1.3 Objectives
The main reason TTU3 UTeM Hostel Registration using web and mobile is to:
• Help solve students ' problem during registration day
The THRS allow student to register room first by using web then get
a key for selected room they choose without need to queue and student can
register room anywhere with internet connection. This help student to so lve
their problem.
• Help officer to reduce cost and time in managing students registration
The THRS helps officer to manage hostel , student, notification and
registration in term of reduce time and cost. By using THRS, the compulsory
student will select based on specific criteria choose by officer and the
noti fica ton about registration room by mobile will send to selected student.
The room key will give student who register by THRS and THRS update for
return room key after end of semester and session.
• Allow a system to manage bostel registration
By using THRS, the officer can manage hostel and student and
registration easily. Also, student can use system to register room by choose
2
1.2 Problem Statement
• Student problems exist during registration day
The student needs to get a long queue if the students come in larger
amount of student at certain time. Besides that, the problem exists to student who
has reason that cannot come to register room at specific time and date.
• Waste time and cost
The letters need to be send to all students that selected to register room at
TTU3 hostel. Then, selected student needs choose the room by manually from
empty room list from a sheet of paper, gets a key for a room and then officer
need key in data manually in existing system after registration finished. All that
activities are waste a time and cost.
• No specific system that can allow student to register room and submit hostel
appeal application form
The existing system only manage allocate student each hostel which
manage by hostel officer. Then, the system not manage student that apply appeal
hostel.
• Late or no notification about student's registration details
The letters are submit to selected student, Year 2 for details of
registration. The problem exists when the letter not arrive to selected student or
arrive lately. For apply student, after submit their application form to office, they
need waiting to get their status about appeal TTU3 hostel either success of fail.
In certain problem, they have trouble to know their status based on available
room in shorted period time. The status is know after officer or staff of hostel