Dormitory Management System in PHP and MySQL Capstone Project

Dormitory Management System in PHP and MySQL Capstone Project

Abstract

A dormitory is a place that offers people a space to sleep for how long they pay for it. Dormitories can be boarded by a large number of students or other people. This study was carried out by the researchers to evaluate the current dormitory management methods. The researchers gathered data and discovered that boarding house owners and landladies/landlords face significant obstacles in managing boarding houses efficiently. Monitoring tenant payments, the availability of rooms and beds (available or occupied), water and electricity bills, and much more are all part of dormitory management. Previously, these management areas were manually processed. To manage the aforementioned areas, the majority of dormitories employ a manual approach. The dormitory’s operation will be slowed by manual operation, which will have an impact on the guests’ experience while staying in their rented rooms and beds. The Dormitory Management System project is a web-based system that was designed and developed using PHP, MySQL, and Bootstrap. The dorm owner had ordered that the project be completed to automate the dorm’s transactions. The owner outlined the transaction flow, which the developers subsequently translated into a technical format in the form of a data flow diagram, entity relationship diagram, and finally a prototype. The program was then put through its paces by IT specialists, who graded it using the McCalls Software Quality Model. IT professionals recommended various additions and functionalities for the system’s development; the researchers then tweaked the system before handing it over to end-users for user acceptability testing. The researchers showed the end-users the results and gave them instructions on how to use the newly created project.

Introduction 

The usage of technology will help businesses automate operations and transactions with their clients. The capstone project, entitled “Dormitory Management System” is designed specifically for dormitory management automation. The system will help owners efficiently manage the operation of the dormitory, from the management of dormitory tenants, rooms, payments, and other important records and transactions.

A dormitory is a place that offers people a space to sleep for how long they pay for it. Dormitories can be boarded by a large number of students or other people. Conventionally, dormitories are managed manually. The owner or manager records information of the boarders or tenants, records of rooms and beds, water and electricity bills, income and expenses, and other transactions of the dormitory. The manual operation involves loads of paper works which require physical storage. Records are not highly accurate and reliable and are prone to human errors. Dormitory owners need an effective system to automate the management processes in dormitories.

Proposed Solution

To address the aforementioned concerns, the researchers of the study proposed the development of the Dormitory Management System. The said project is designed to automate recording and management information of the boarders or tenants, records of rooms and beds, water and electricity bills, income and expenses, and other transactions of the dormitory. The project will eliminate paperwork and manual management in the dormitory. Records also will be accurate, reliable and are electronically stored for easy retrieval. The system will increase the operational efficiency of the dormitories as well as the tenant’s overall experience.

Objectives of the Study

General Objective – The main goal of the researchers is to design, develop and implement a Dormitory Management System that digitally transforms management operations and processes in the dormitory.

The researchers specifically aim the following objectives :

  1. To establish a centralized tenant records management and management reporting system.
  2. To make dorms run more smoothly in general.
  3. The owner or manager of the dormitory’s workload should be reduced and minimized.
  4. To improve the efficiency of the dormitory’s operations and the occupants’ experience while there.
  5. To assess the system’s usability, functionality, effectiveness, quality, productivity, and dependability from the perspective of the users.

Scope of the Study

This research focuses on the Dormitory Management System’s development process. The researchers will create, test, and implement a Dormitory Management system that will make it easier to manage dormitory operations and transactions. The system is solely intended for usage in dormitories. Owners, managers, and tenants will be among the survey’s participants.

Dormitory Management System in PHP and MySQL Capstone Project
Dormitory Management System in PHP and MySQL Capstone Project

Significance of the Study

Dormitories Owners. The solution will assist them in increasing their business productivity and allowing them to keep up with technology advancements in dormitory management.

Managers. The system will allow them to track and monitor tenant payments, room and bed availability (available or occupied), water and power costs, and report generation simply and efficiently. They can manage the dormitory’s entire operation with ease and efficiency.

Tenants. The system will help them have a better overall experience in the dorm. They have personal access to their payment data as well as the ability to electronically communicate their problems and complaints about the dormitories.

Researchers. Their experience in conducting the project will further enhance their knowledge and skills as researchers.

Future Researchers. The study can serve as their guide if they wish to design and develop their version of the Dormitory Management System.

Development Tools

On request, project documentation can be obtained (chapters 1 to 5). Please contact us if you require the project’s full documentation.

Project Highlights 

The Dormitory Management System is a database-driven system that automates tenant payment, room and bed status, water and power bills, and report generating.

The following are some of the benefits of the Dormitory Management System:

  1. Automated management- the technology will allow for computerized dormitory management.
  2. Records Management – This is a database system that makes electronic, safe, accurate, reliable, and fast records of the dormitory’s operations.
  3. Generation of Reports – The system can generate reports on payments, bills, and the state of rooms and beds in a dorm.

How the System Works

The forms, modules, and user interface of the Dormitory Management System will be explained in this article. We’ll go through the system’s features and how it operates.

Dashboard – This dashboard serves as the main page of the system administrator. The admin can view and access major records of the system.

This module displays the following:

  • number of rooms
  • number of room type
  • number of customers

The image displayed below is the design of the system’s Dashboard.

Dormitory Management System Dashboard Module
Dormitory Management System Dashboard Module

Customer Management Module – This module allows the user to encode customers and their corresponding details.

The following information of the customers will be encoded:

  • Full name
  • Contact number
  • Address
  • Age
  • Email
  • Username
  • Password

Shown below is the layout of the Customer Management module.

Dormitory Management System Customer Management Module
Dormitory Management System Customer Management Module

Room Type Management – This module allows the user to add/edit the type of room.

The image shown below is the design of the Room Type Management module.

Dormitory Management System Room Type Module
Dormitory Management System Room Type Module

Visit the link for more information about the project and download the template in PHP and Bootstrap.

Dormitory Management System in PHP and MySQL User Interface

Conclusion

Effective dormitory administration necessitates the use of a system. The goal of this research was to create an automated Dormitory Management System. The initiative will technologically streamline the dormitory’s operations, resulting in more effective management. The developed system was shown to the intended users and respondents, and the results demonstrated that the system met their needs and requirements. The system was scored satisfactorily by the majority of respondents in terms of user acceptability, effectiveness, quality, productivity, and dependability.

As a result, the researchers concluded that the system is effective at automating the process of dormitory management. The system will allow dormitory owners and managers to monitor and track the dorm’s operations electronically. The system will act as an online platform for tenants and dorm management to record and transact information. The new system will improve operational efficiency and the dorm tenants’ overall experience.

FREE DOWNLOAD SOURCE CODE

Recommendations

The researchers strongly advise the implementation of the Dormitory Management System based on the study’s positive findings. Dormitory management becomes more effective and efficient after the developed system is implemented. Manual processes and errors will be minimized, allowing the dorm to run more smoothly. The system’s adoption will make dormitory management simple, quick, convenient, accurate, and dependable. According to the researchers, the target end-users must understand how the system works to use it properly.

The researchers’ specific recommendations are as follows:

  1. It is recommended that dormitory owners use the system to run their business to simplify management and provide the best possible service to their tenants.
  2. The researchers recommend that dorm managers use the technology to help them manage dormitories more efficiently.
  3. The system is suggested because of its efficiency and dependability in serving the target end-users.
  4. The system’s implementation is strongly recommended because it will make dorm management simple, quick, convenient, accurate, and dependable.

You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive  free capstone projects resources and computer programming tutorials.

Hire our team to do the project.

Related Links and Articles:

Web Based Boarding House and Dormitory Management System

Dormitory Management System Review of Related Literature

Boarding House and Dormitory System ER Diagram

Top 35 Free School Related IT Capstone Project

Advance School Management System

Dormitory Management System in PHP and MySQL User Interface

Vaccine Distribution System Bootstrap Template

, , , , , ,

Post navigation