ONLINE DORMITORY RESERVATION SYSTEM By RAMYA VAKITY KOUSHIK

ONLINE DORMITORY RESERVATION SYSTEM By RAMYA VAKITY KOUSHIK KUMAR SURAGONI MOTHE ADITHYA GRADUATE CAPSTONE SEMINAR PROJECT Submitted in partial fulfillment of the requirements For the Degree of Master of Science, With a Major in Computer Science Governors State University Park, IL 60484 FALL-2015

Team Members: Adithya Ramya Koushik 2

Abstract This project is Online Dormitory Reservation Systems which allows users to book their room in the dorm from anywhere. This is an automated online system where the user can search the availability of rooms and reserve the room in the dorm. 3

Existing system The existing system does not contain any online facility to reserve a room in the dorms remotely. All they have in Our University is to check online for the rooms but can not reserve a room. And it’s PROBLEMS: Only we can make appointments but can not reserve a room. No scope for storage of user info. There is no information reusability. 4

Proposed system The proposed system organizes the data effectively. The online dorms system for improving application Quality and Reliability is a web based application that can be accessed throughout the organization. The main advantage is that the user have the capability of reserving the room for 48 hours. 5

Architecture The project has been developed in Model-2 architecture. Model 2 is a complex design pattern used in the design of java web applications, which separates the display of content from the logic used to obtain and manipulate the content. Since Model 2 drives a separation between logic and display. . 6

Model 2 Architecture 7

Modules There are 3 modules in the project: • UI Creation and Database design • User Module • Administrator Module 8

UI Creation and Database design: In the initial phase of the implementation the User Interface has to be designed, which makes user feel comfortable. It will support the user to check the availability of the beds according to the dates. Once UI design completed, then main focus is on database design. The database will be designed with all the required tables and the relationships derived. 9

User Module The second module in the project is to satisfy all the user’s requirements. This module starts with designing a user account for the respective user. In this module user can register with the System by giving his personal information. Once the registration is completed the user can login in to the system and can check for the availability of the beds. 10

Administrator Module In this module the administrator’s activities are developed. The administrator can add a bed or delete a bed. He has all the control over the system. The administrator can login with his email address and password. Here the password is encrypted and stored in the database using some encryption algorithms. While retrieving the password to login the system decrypts the password using respective decryption algorithms. 11

Home page 12

Overall bookings 13

Database contains 3 tables Customer details Admin_Login Hostel 14

Database Design In this application I have created a database with the name hostels and designed 3 tables to store the data. They are: Admin_Login – Administration Details Hostel 21: stores the information about the beds and rooms that are present in the dorm Customer_details: this table stores the information about the customer 15

Database – Hostel table 16

UML Diagrams 17

Activity Diagram 18

System requirements Required Hardware: System : Processor i 3. Speed : 2. 2 GHz Hard Disk : 500 GB. Ram : 2 GB. Required Software: Operating system : Windows OS Language : Java 1. 6 or java 1. 7 Framework : JSP(Java Server Page) Backend : Oracle Backend Interaction Language: My. SQL 19

Conclusion We conclude that our project “Online Dormitory System” is developed and implemented by overcoming many problems in creating a user friendly and reliable system. 20

21