DESIGN AND IMPLEMENTATION OF A COMPUTERISED HOSTEL ALLOCATION SYSTEM


DESIGN AND IMPLEMENTATION OF A COMPUTERISED HOSTEL ALLOCATION SYSTEM

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.

1.3.0    PROBLEM DEFINITION

Problems associated with hostel records when manually handled by hostel staffs in University of Calabar include:

⦁    Records are manually written and stored in various registers.

⦁    Lots of human errors are encountered when records are hand-written.

⦁    The use of numerous registers for hostel allocation can be very cumbersome, hence tracing records become tedious.

⦁    Difficulty in maintaining or updating the records, hence, retrieval of a certain dataset from a bunch of registers is almost impossible.

⦁    Loss or damage of any of the registers leads to damage of lots of important files at a time.

⦁    Lack of data security.

1.4.0    OBJECTIVE OF STUDY

The objective of this study is to develop an application that will ease the stress associated with the existing manual system as earlier stated, while focusing on the the of University of Calabar.

This study aims to achieve the following;

i.    To create a database management system (DBMS) which allocates storage to student data and also provides security for the stored data.

ii.    To provide quick and efficient means for gathering the student information along with their rooms, fees, etc.

iii.    To find out the possible benefits that will be obtained from the new system.

iv.    At the completion of this work, this system will improve the management of student hostels in the University of Calabar.

1.5.0    RESEARCH JUSTIFICATION

The proposed research can be justified by providing answers to the questions below:

i.    Does the research extend the understanding of the phenomenon being investigated?

ii.    Does it elaborate, extend or fill in gaps in present knowledge?

iii.    Finally, will it give the expected results result?

After putting these aforementioned questions into consideration, I believe that this research is worth doing. Using UNICAL as the existing system to be investigated, in which the mode of operation is done manually, a certain level of bias will be experienced. The new system to be developed is to manage the allocation process.

1.6.0    RESEARCH METHODOLOGY

In order to realize the objectives of this research, it is important to apply the appropriate strategy in achieving the set goals. The methodology employed in the course of this study is to first outline the set of requirements to be met by the proposed system, where information related to the research work will be derived from the area of study (University of Calabar Hostels and Student Affairs); then envisage and implement the design of the system, using HTML and PHP for the design and MySQL for building the database.

1.7.0    SCOPE AND LIMITATION OF STUDY

In terms of geographical coverage, student hotels in University of Calabar, Calabar, was studied.

This study suggests means of gathering information about students and ways of easily managing the hostel details, room details, student records, easy way of room allocation and hostel attendance. Subsequently, software will be written in the implementation phase which will enable the program to run.

In addition to this, a number of things occurred which slowed down the process in the research work. They include:

i.    Time constraint for proper analysis, design and implementation of the E-Hostel system.

ii.    Poor internet facilities and inaccessible websites.

iii.    Limited access to administrative information.

1.8.0    DEFINITION OF TERMS

Database Management System (DBMS): is software that enables you store, modify, and extract information on a database.

E-Hostel (Electronic Hostel):  is a computerized system for managing various activities in the hostel.

MySQL:MYSQL is a relational database management system written in C and C++ that runs as a server providing multi user access to a number of databases.

PHP: Hypertext Preprocessor is a scripting language originally designed for producing dynamic web pages.

Unified Modeling Language (UML): It is used to specify, visualize, modify, construct, and document the artifacts of an object-oriented software-intensive system under development.

1.9.0    CHAPTER LAYOUT

This study is presented in five chapters.

Chapter One: deals with the introduction, which provides preamble or background to the study. It also introduces the study and provides relevant information on the background to the study, problem definition, objectives of study, justification and methodology of the research, definition of terms and chapter layout.

Chapter two: is a review of literature relevant to the research topic; introduction to the chapter, overview of hostel and brief history of hostel will be discussed. Also to be discussed are the type of hostels and a quick look on several literature on this work before ending with my proposed contribution.

Chapter three: presents system methodology which analyzes the current system, indicating the shortcomings and finding possible solutions by designing and developing a new system. System requirements and specifications are also discussed.

Chapter four: focuses on system implementation which aims at ensuring that the system works accurately and efficiently and also tested for possible errors before making it available to the users.

Chapter five: provides a summary of the findings, drawing conclusions based on the findings as well as the relevant recommendations

.

DESIGN AND IMPLEMENTATION OF A COMPUTERISED HOSTEL ALLOCATION SYSTEM



TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.ORG

Researchwap.org is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.org guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.org is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.org" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.