ABSTRACT
This
Project work intends to address some of the problems encountered in the
allocation of hostels to students manually in Universities, using University of
Calabar as the case study. The growing number of students in higher
institutions posed a lot of accommodation problems on the part of students and
school management. Some of the problems encountered include, few hostels that
exist in the University are not properly managed, statistic of rooms required
to match the growing number of students are farfetched, students who have paid
hostel fees may end up not getting rooms
because of lack of bed, Hostel administrators cannot give accurate information of
the occupancy of a particular room. In respect to all of these existing
problems, it became necessary to design a system capable of managing a database
which allocates hostel to student. The system to be designed will keep track of
all the available rooms and its occupants. This hostel management system was
implemented using HTML, PHP and MySQL.
TABLE
OF CONTENT
TITLE
PAGE --- --- --- --- --- --- --- --- i
CERTIFICATION
--- --- --- --- --- --- --- ii
DEDICATION
--- --- --- --- --- --- --- --- iii
ACKNOWLEDGEMENT
--- --- --- --- --- --- iv
ABSTRACT
--- --- --- --- --- --- --- --- v
TABLE
OF CONTENT --- --- --- --- --- --- vi
LIST
OF FIGURES --- --- --- --- --- --- --- x
LIST
OF TABLES --- --- --- --- --- --- --- xi
CHAPTER
ONE: INTRODUCTION
1.1.0 General introduction --- --- --- --- --- --- 1
1.2.0 Introduction --- --- --- --- --- --- --- 1
1.3.0 Problem definition --- --- --- --- --- --- 2
1.4.0 Objective of study --- --- --- --- --- --- 3
1.5.0 Research justification--- --- --- --- --- --- 4
1.6.0 Research methodology --- --- --- --- --- 4
1.7.0 Scope and limitation of study --- --- --- --- 5
1.8.0 Definition of terms --- --- --- --- --- --- 6
1.9.0 Chapter layout --- --- --- --- --- --- 6
CHAPTER
TWO: LITERATURE REVIEW
2.1.0 Introduction --- --- --- --- --- --- --- 8
2.1.1 Overview of Hostel System --- --- --- --- --- 8
2.1.2 Brief history of Hostel Systems --- --- --- --- 9
2.2.
Type of Hostels --- --- --- --- --- --- --- 10
2.2.1 Hostelling International (HI) (Wikipedia, 2013) --- 11
2.2.2 Independent Hostels --- --- --- --- --- --- 11
2.2.3 Boutique Hostels (Wikipedia, 2013) --- --- --- 12
2.2.4 Mobil Hostesl (Wikipedia, 2013) --- --- --- --- 13
2.3.0 State-of-the-Art E-Hostel Systems--- --- --- --- 14
2.3.1 Hostel Reservation Script --- --- --- --- --- 14
2.3.2 Anand System Inc --- --- --- --- --- --- 15
2.4.0 Proposed Contributions --- --- --- --- --- 16
CHAPTER
THREE: SYSTEM DESIGN METHODOLOGY
3.1.0 Introduction --- --- --- --- --- --- --- 17
3.2.0 System Requirements Specification --- --- --- 17
3.3.0 System Design --- --- --- ---- --- --- --- 18
3.3.1.0
Logical Design --- --- --- --- --- --- 18
3.3.1.1
Input Design --- --- --- --- --- --- --- 18
3.3.1.2
Output Design --- --- --- --- --- --- --- 22
3.3.1.3
Menu Design --- --- --- --- --- --- --- 23
3.3.1.4
Use Case Design --- --- --- --- --- --- 25
3.3.1.5
Activity Design --- --- --- --- --- --- 25
3.3.1.6
Program flowchart --- --- --- --- --- --- 27
3.3.2.0
Physical Design --- --- --- --- --- --- 29
3.3.2.1
Program Specification --- --- --- --- --- 29
3.3.2.2
Layout of Files Design --- --- --- --- --- 33
3.3.2.3
System Controls --- --- --- --- --- --- 36
3.3.2.4
Structure of Database Design --- --- --- --- 37
CHAPTER
FOUR: SYSTEM IMPLEMENTATION
4.1.0 Introduction --- --- --- --- --- --- --- 38
4.2.0 Features and Choice of Implementation
Language --- 38
4.3.0 System Testing Strategies --- --- --- --- --- 41
4.3.1 Unit Test --- --- --- --- --- --- --- 41
4.3.2 Integration Test --- --- --- --- --- --- 42
4.4.0 Target Computer System Requirements --- --- 43
4.4.1 Software Requirements --- --- --- --- --- 43
4.4.2 Hardware Requirements --- --- --- --- --- 44
4.5.0 Software Maintenance Issues ---- --- --- --- 44
4.5.1 Corrective Maintenance --- --- --- --- --- 45
4.5.2 Preventive Maintenance --- --- --- --- --- 45
4.5.3 Adaptive Maintenance --- --- --- --- --- 46
CHAPTER
FIVE: RECOMMENDATION AND CONCLUSION
5.1.0 Introduction --- --- --- --- --- --- --- 47
5.2.0
Application of the E-Hostel System to UNICAL Hostel
Allocation --- --- --- --- --- --- --- 47
5.3.0 Suggestion on Further Research --- --- --- 48
5.4.0 Recommendation --- --- --- --- --- --- 49
5.5.0 Conclusion --- --- --- --- --- --- --- 50
REFERENCES
--- --- --- --- --- --- --- 51
APPENDICES
--- --- --- --- --- --- --- 52
Appendix A: Source Code Listings
Appendix B: Sample Output
LIST
OF FIGURES
Figure 3.1 Login Interface --- --- --- --- --- 19
Figure 3.2 Update Hostel Interface --- --- --- --- 20
Figure 3.3 Allocate Hostel Interface --- --- --- --- 21
Figure 3.4 View Allocation Interface --- --- --- --- 22
Figure 3.5 Search Field Interface ---- ---- ---- --- 23
Figure 3.6 Menu Design --- --- --- --- --- --- 24
Figure 3.7 Use Case Diagram --- --- --- --- --- 25
Figure 3.8 Activity Diagram for the Proposed System --- 26
Figure 3.9 Flowchart of the Proposed System --- --- --- 28
LIST
OF TABLES
Table 3.1 Layout of User Table --- --- --- --- --- 33
Table 3.2 Layout of Hall Table --- --- --- --- --- 34
Table 3.3 Layout of Student Table --- --- --- --- 35
Table 4.1 Software Requirement for the Target System
--- 43
Table 4.2 Hardware Requirement for the Target System
--- 44
CHAPTER ONE
INTRODUCTION
1.1.0
GENERAL INTRODUCTION
It
is safe to say that most activities such as hostel allocation carried out in
most universities in Nigeria are done manually. Therefore, there is a lot of
strain on the individuals running the hostels. An E-Hostel system is simply
software developed for managing most activities that take place in the hostels
with the help of a hostel administrator.
The
goal of this research work is to provide a solution to the problem of hostel
management, by designing a computerized system which is user-friendly and
GUI-oriented that will be compatible with the existing manual systems. The
software to be developed will solve the problem of hostel management; thus
helping to reduce problems associated with the manual hostel management system.
The project uses University of Calabar as Case Study.
1.2.0
INTRODUCTION
This
chapter introduces the study and provides relevant information on the
background of the study. It begins with problem definition (statement of the
problem) which describes the major problems associated with manual hostel
management. This is followed by the research objective putting in a nutshell
what is to be achieved by the study. Subsequently, the Research Justification
is presented, which justifies the essence of the research. The Research
Methodology describes the procedures used in conducting the research. Scope and
Limitation discusses the area the research is limited to and also highlights
the constraints encountered during the course of this work. Finally, there is
definition of terms and chapter layout which defines peculiar terms related to
the study alone and summarizes the entire chapters respectively.