Download Summary, Hotel Room Reservation System: Database Design and Implementation and more Summaries Database Management Systems (DBMS) in PDF only on Docsity!
Hotel Room Reservation System
Project Report
Hotel Room Reservation System
This document summarizes a DBMS mini-project report on a Hotel Room Reservation System. The project was submitted in partial fulfillment of the requirements for a Bachelor of Engineering degree in Artificial Intelligence and Machine Learning at Visvesvaraya Technological University by Akshay Satheesh (1RN20AI010) of RNS Institute of Technology during the academic year 2022-23.
Project Overview
The Hotel Room Reservation System is designed for Alpha Royal Hotel, a fictional establishment. It is a web-based application, accessible through a web browser, and implemented using PHP and HTML. The system allows users to book rooms at any time and from any location via the internet. The system is designed to be user-friendly.
Table of Contents Summary
The report includes the following sections: Acknowledgement, Abstract, Introduction (including an overview of Database Management Systems, the problem statement, and objectives), System Requirements (software and hardware), System Design (E-R Diagram, Schema Diagram, GUI Overview, and Normalization), Implementation (Table Creation, Table Description, Populated Tables, SQL Triggers & Stored Procedures, Database Connectivity, and Front End Source Code), Results, and References/ Bibliography.
Introduction
Overview of Database Management Systems
Database technology provides an internal representation of the external world. It focuses on maintaining consistency between the internal representation and external reality. This involves user requirements analysis, data modeling, process modeling, data integrity, concurrency, transactions, file organization, indexing, rollback and recovery, persistent programming, object-orientation, logic programming, deductive database systems, and active database systems. Database technology is a core technology linked to information management/processing, data analysis/ statistics, data visualization/presentation, multimedia and hypermedia, office and document systems, business processes, workflow, and CSCW.
Relational DBMS is a base technology for business applications. Extended Relational Systems extend facilities in directions like information retrieval, object-orientation and deductive/active systems. Deductive / Active DBMS combines logic programming technology with database technology.
DBMS allows entities and relations to form tables. A database is an active entity, whereas data is passive. DBMS stores metadata. Consistency ensures every relation in a database remains consistent. DBMS provides greater consistency compared to file-processing systems. A query language makes it efficient to retrieve and manipulate data. DBMS follows ACID properties (Atomicity, Consistency, Isolation, and Durability) on transactions. It supports multi-user environment and concurrent access. DBMS offers multiple views for different users and security features.
Examples of DBMS usage include banking systems (storing customer information, tracking transactions, generating statements) and the education sector (storing student, staff, course, exam, payroll, attendance, and fee details).
Problem Statement
The Hotel Room Reservation System is a website where customers can reserve/book hotel rooms. It involves user categories such as rooms, admins, and users. The admin can add new categories of users, new rooms, and perform managerial tasks. It also provides information about the hotel's total sales.
Objectives
The primary objective is to provide customers with a convenient and efficient way to book accommodations.
System Requirements
Hardware Requirements
The hardware requirements are minimal, and the program can run on most machines. The operating system used is Windows 11.
Software Requirements
The technologies used are HTML, CSS, PHP, and Bootstrap. A browser that supports HTML is also required.
System Design
E-R Diagram
The report includes an E-R Diagram (Figure 3.1).
language used for web development. PHP is a backend scripting language. MariaDB is a database system derived from MySQL.
Database Anomalies and Normalization
Update anomalies can occur if data items are scattered and not properly linked. Insert anomalies can occur when attempting to insert data into a non-existent record. For a relational table to be in second normal form, it must first be in first normal form. Additionally, it must not contain any partial dependency, meaning all non-prime attributes must be fully functionally dependent on the primary key.
Implementation
Table Creation
The following SQL CREATE TABLE statements define the database tables for the Hotel Room Reservation System:
ADMIN
CREATE TABLE admin ( id int(11) NOT NULL, username varchar(100) NOT NULL, password varchar(100) NOT NULL, img varchar(20) NOT NULL )
USER
CREATE TABLE user ( id int(11) NOT NULL, name char(50) NOT NULL, email varchar(50) NOT NULL, password varchar(100) NOT NULL, mobile bigint(20) NOT NULL, address varchar(255) NOT NULL, gender enum('male','female','other') NOT NULL, country varchar(50) NOT NULL, pictrure varchar(255) NOT NULL )
ROOMS
CREATE TABLE rooms ( room_id int(11) NOT NULL, room_no int(11) NOT NULL, type varchar(100) NOT NULL, price bigint(20) NOT NULL, details text NOT NULL,
image varchar(255) NOT NULL )
ROOM_BOOKING_DETAILS
CREATE TABLE room_booking_details ( id int(11) NOT NULL, name char(50) NOT NULL, email varchar(50) NOT NULL, phone bigint(20) NOT NULL, address varchar(255) NOT NULL, city varchar(100) NOT NULL, state varchar(100) NOT NULL, zip int(20) NOT NULL, contry varchar(50) NOT NULL, room_type varchar(100) NOT NULL, check_in_date date NOT NULL, check_in_time varchar(6) NOT NULL, check_out_date date NOT NULL, Occupancy varchar(100) NOT NULL )
PAYMENT
CREATE TABLE payment ( id int(11) NOT NULL, name varchar(20) NOT NULL, email varchar(20) NOT NULL, amount int(11) NOT NULL, status varchar(10) NOT NULL )
FEEDBACK
CREATE TABLE feedback ( id int(11) NOT NULL, name varchar(100) NOT NULL, email varchar(100) NOT NULL, mobile bigint(20) NOT NULL, message varchar(255) NOT NULL )
Table Descriptions
The text mentions descriptions of the tables admin, user, rooms, room_booking_details, payment, and feedback are available, referenced as figures 4.1 through 4.6 respectively.
source SQL database management system. SQL is the standardized language for accessing databases. The MySQL Database Server is known for its speed, reliability, and ease of use.
Source Code (Front End)
Index.php
The index.php file includes PHP code to start a session, handle error reporting, and include a connection file. It displays a welcome message and room details from the rooms table. It also includes the Menu Bar.php and Footer.php files.
Menu Bar.php
The Menu Bar.php file includes PHP code to start a session and handle error reporting. It displays a navigation menu with links to Home, About, and Gallery pages. It also includes links for Admin Login and User Login/ Logout based on the session status.
Login.php
The Login.php file includes PHP code to start a session, handle error reporting, and include a connection file. It handles user login authentication. If the login is successful, it redirects the user to Booking Form.php.
Profile.php
The Profile.php file includes PHP code to start a session, handle error reporting, and include a connection file. It retrieves the user's email from the session.
Hotel Room Reservation System
This document pertains to the development of a Hotel Room Reservation System. It appears to be part of a Bachelor of Engineering (BE) project from the Department of AI&ML, RNSIT, during the academic year 2022-23. The system is identified by the code 18CSL58.
User Profile Update
The system includes functionality for users to update their profiles. This involves updating information such as name, password, mobile number, and address. The update is performed using a PHP script that executes an SQL query to modify the user data in the database. A success message is displayed upon successful update.
User Interface
The user interface is built using HTML, CSS, and potentially JavaScript. It includes elements such as forms for inputting user data, labels, and buttons. The design incorporates a container-fluid layout with specific styling for elements like the user profile heading. The profile page displays user information retrieved from the database.
System Pages
The document includes figures showcasing various pages of the system:
Index page (header and content) Footer About Us page Image Gallery page User Login page Admin Login page Booking Form page User Profile page Rooms page Invoice page Booked Room Details page Admin Dashboard Admin Edit (Feedback) Admin Edit (Room Details) Admin Edit (Room Booking Details)
Technologies Used
The system is implemented using technologies such as JavaScript, HTML, and PHP. PHP handles dynamic content, and a database is used for persistent data storage.
References
The document references resources related to PHP and MySQL web development, including books by Kevin Yank and other publications from SitePoint Pty Ltd, Peachpit Press, and O'Reilly & Associates, Inc.
