Dormitory Management System in PHP and MySQL User Interface
Abstract
The project entitled Dormitory Management System is a web based system designed and developed in PHP, MySQL and Bootstrap. The said project was actually requested by the dorm owner for the purpose of automating the transactions in the dorm. The owner described the flow of transactions then the developers translated it into a technical manner in a form of data flow diagram, entity relationship diagram and eventually converted the ideas into a prototype. The program was then tested by the IT experts and rated the system using the McCalls Software Quality Model. IT experts suggested several features and functionalities for the improvement of the system; the system was then modified by the researchers before it was handed out to the end users for user acceptance testing. The researchers presented the output to the end users and conducted training on how to utilize the newly developed project.
Development Tools:
PHP (Hypertext Pre-processor)
is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML (www.php.net).
HTML5
Hypertext Markup Language revision 5 (HTMl5) is markup language for the structure and presentation of World Wide Web contents. HTML5 supports the traditional HTML and XHTML-style syntax and other new features in each markup, New APIs, XHTML and error handling (www.techopedia.com).
CSS (Cascading Style Sheet)
are used to format the layout of Web pages. They can be used to define text styles, table sizes, and other aspects of Web pages that previously could only be defined in a page’s HTML (www.techterms.com).
Bootstrap
is a powerful front-end framework for faster and easier web development. It includes HTML and CSS based design templates for common user interface components like Typography, Forms, Buttons, Tables, Navigations, Dropdowns, Alerts, Modals, Tabs, Accordion, Carousel and many other as well as optional JavaScript extensions. Bootstrap also gives your ability to create responsive layout with much less efforts using Bootstrap is that it comes with free set of tools for creating flexible and responsive web layouts as well as common interface components. The Bootstrap data APIs you can create advanced interface components like Scroll spy and Type a heads without writing a single line of JavaScript (tutorialrepublic.com).
MySQL
is an open source relational database management system (RDBMS) based on Structured Query language (SQL) (www.searchoracle.techtarget.com).
Php MyAdmin
is a free software tool written in Php, intended to handle the administration of MySQL over the web. (www.phpmyadmin.net).
System Module and User Interface
- Dormitory Management System Dashboard Module
Module Description: This module displays the number of rooms, number of room type and number of customers.
Table Fields and Entities: No. of Rooms, No. of Room Types, No. of Customer.
- Dormitory Management System Room Type Module
Module Description: This module allows the user to add/edit type of room.
Table Fields and Entities: roomtypeid, roomtypename
- Dormitory Management System Room Management Module
Module Description: This module allows the user to add and manage the available rooms and other details such as room number, room name, room description, no. of beds, images, rate per night, room type.
Table Fields and Entities: roomid, roomnumber, roomname, description, numberofbeds, images, ratepernight, roomtypeid
- Dormitory Management System Customer Management Module
Module Description: This module allows the user to encode customers and their corresponding details.
Table Fields and Entities: customerid, customername, contact, address, age, email, username, password
- Dormitory Management System Guardian Management Module
Module Description: In this module, the user can add/edit the guardians of their customers.
Table Fields and Entities: guardianid, guardianname, contact, address, customerid
- Dormitory Management System Booking Management Module
Module Description: The user can add/edit booking by providing the details needed such as room, customer name, started date, end date, total amount, status, and the user that booked the room.
Table Fields and Entities: bookingid, roomid, customerid, starteddate, enddate, totalamount, status, userid
- Dormitory Management System Payment Management Module
Module Description: in this module the user can easily place a payment by providing the payment amount, start and end date, and the discount.
Table Fields and Entities: paymentid, bookingid, datefrom, dateto, paymentamount, discount, userid
- Dormitory Management System User Management Module
Module Description: This module allows the administrator to manage the users of the system. The admin can add/edit users by providing user name, password, contact name, contact number, and account type.
Table Fields and Entities: userid, username, password, contactname, contact, accounttype
- Dormitory Management System Income Report Module
Module Description: this module displays the income report of each month and presented in graphical bar chart.
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.