This document is a dissertation submitted by Sehaj Kour Raina for the degree of Bachelor of Technology in Computer Science and Engineering at Lovely Professional University. The dissertation describes developing a Hotel Management System with an entity relationship diagram, database schemas, normalization, and SQL implementation. It includes sections on the E-R diagram, entities and attributes, relationships, normalization to third normal form, and PL/SQL code for creating tables in the hotel database.
The document is a summary of a student's hostel management system project. It includes acknowledgements, an abstract, table of contents, introduction, system analysis, design, implementation, testing, and conclusion sections. The introduction defines the problems with existing manual hostel management systems and the objectives of the proposed computerized system. The system analysis compares the existing and proposed systems. The proposed system aims to automate processes, provide quick access to accurate information, and reduce costs and errors compared to the manual system. The system design and implementation sections describe the hardware, software, database tables, user interfaces, and coding used to develop the project.
This document describes a proposed notes and password manager mobile application. It will allow users to manage both notes and passwords from a single application, reducing space. Key features include user login, viewing and managing notes and passwords, and storing this data in Firebase database. The application will be developed in Android Studio using Java and will implement authentication, home screen with note and password options, and functionality to add, delete, update notes and passwords.
This document describes an online hotel management system project. The proposed system allows customers to reserve hotel rooms online, check availability and view facilities. It has user and administrator modules. The user module allows customers to register, login, check availability, reserve rooms and cancel reservations. The administrator module allows managing reservations, viewing daily reservations and income. The system will be developed using PHP for the platform, MySQL for the database, and XAMPP as the web server. It provides UML diagrams including use case, sequence, activity and class diagrams to design the system.
This document describes an online hotel management system that allows customers to reserve hotel rooms online. It discusses the existing manual hotel reservation system and proposes a new online system. The proposed system would allow users to check availability, make reservations, and get hotel information online. It would also give administrators access to reservation details and income reports. The system would use a user module for customers and an administrator module for hotel management.
This document provides an overview of a proposed railway reservation system project. The goals are to automate the reservation process and make it more efficient and fast. The system will include modules for train schedules, seat allocation, fare calculation, and administration features. It aims to provide security, accuracy, and reduce manual work while giving users and administrators a friendly interface. The software will use Visual Basic and MS Access, and require at least 512MB RAM and 20GB hard disk on Windows OS.
The document summarizes the key chapters and objectives of a hotel management system project. It discusses that the project aims to automate the main activities of a hotel like room management, customer admission and checkout, and billing. It analyzes the current manual system and outlines the objectives of the new computerized system, including improved efficiency, user-friendliness, flexibility and security. The system is designed to handle room bookings, packages and customer reports for both online users and administrators.
Hotel ITM Villa aims to automate their reservation system to avoid manual and repetitive work, provide real-time room availability information, and allow guests to search for and reserve rooms online. The proposed system will use a relational database and .NET technology with a website for online booking and a point-of-sale system for front desk staff. It will generate various reports including daily revenue and occupancy, periodic sales and occupancy, and monthly commission reports to improve decision making.
This document describes an online hotel booking system. The system allows users to check availability, book rooms, and manage reservations online through a website. It has two main modules: an administrator module that can manage customer and room details and update room status, and a user module that allows users to check availability, fill out reservation forms, and receive reservation confirmations. The system was developed using ASP.NET for the front end, SQL Server 2008 for the database, and C# and HTML/CSS for programming. Entity relationship diagrams and data flow diagrams are also included to show the database and system design.
The document is a summary of a student's hostel management system project. It includes acknowledgements, an abstract, table of contents, introduction, system analysis, design, implementation, testing, and conclusion sections. The introduction defines the problems with existing manual hostel management systems and the objectives of the proposed computerized system. The system analysis compares the existing and proposed systems. The proposed system aims to automate processes, provide quick access to accurate information, and reduce costs and errors compared to the manual system. The system design and implementation sections describe the hardware, software, database tables, user interfaces, and coding used to develop the project.
This document describes a proposed notes and password manager mobile application. It will allow users to manage both notes and passwords from a single application, reducing space. Key features include user login, viewing and managing notes and passwords, and storing this data in Firebase database. The application will be developed in Android Studio using Java and will implement authentication, home screen with note and password options, and functionality to add, delete, update notes and passwords.
This document describes an online hotel management system project. The proposed system allows customers to reserve hotel rooms online, check availability and view facilities. It has user and administrator modules. The user module allows customers to register, login, check availability, reserve rooms and cancel reservations. The administrator module allows managing reservations, viewing daily reservations and income. The system will be developed using PHP for the platform, MySQL for the database, and XAMPP as the web server. It provides UML diagrams including use case, sequence, activity and class diagrams to design the system.
This document describes an online hotel management system that allows customers to reserve hotel rooms online. It discusses the existing manual hotel reservation system and proposes a new online system. The proposed system would allow users to check availability, make reservations, and get hotel information online. It would also give administrators access to reservation details and income reports. The system would use a user module for customers and an administrator module for hotel management.
This document provides an overview of a proposed railway reservation system project. The goals are to automate the reservation process and make it more efficient and fast. The system will include modules for train schedules, seat allocation, fare calculation, and administration features. It aims to provide security, accuracy, and reduce manual work while giving users and administrators a friendly interface. The software will use Visual Basic and MS Access, and require at least 512MB RAM and 20GB hard disk on Windows OS.
The document summarizes the key chapters and objectives of a hotel management system project. It discusses that the project aims to automate the main activities of a hotel like room management, customer admission and checkout, and billing. It analyzes the current manual system and outlines the objectives of the new computerized system, including improved efficiency, user-friendliness, flexibility and security. The system is designed to handle room bookings, packages and customer reports for both online users and administrators.
Hotel ITM Villa aims to automate their reservation system to avoid manual and repetitive work, provide real-time room availability information, and allow guests to search for and reserve rooms online. The proposed system will use a relational database and .NET technology with a website for online booking and a point-of-sale system for front desk staff. It will generate various reports including daily revenue and occupancy, periodic sales and occupancy, and monthly commission reports to improve decision making.
This document describes an online hotel booking system. The system allows users to check availability, book rooms, and manage reservations online through a website. It has two main modules: an administrator module that can manage customer and room details and update room status, and a user module that allows users to check availability, fill out reservation forms, and receive reservation confirmations. The system was developed using ASP.NET for the front end, SQL Server 2008 for the database, and C# and HTML/CSS for programming. Entity relationship diagrams and data flow diagrams are also included to show the database and system design.
This document summarizes a project on a hostel management system. It was created by three students and supervised by Nahid Anwar. The project aims to develop a computerized system to more efficiently manage activities at a hostel, avoiding problems of manual record keeping. It will allow administrators to view student profiles, allocate rooms, track payments, and update records. The project follows a waterfall model approach and will analyze requirements, design interfaces and databases, implement features, test the system, and support ongoing maintenance.
This document describes an apartment management system project. The system allows apartment owners to register tenants online rather than using physical registers. It allows administrators to view owner and tenant details. The system manages tenant information and rent payment records. It was developed to more easily organize apartment details, as the previous manual system could not view single user information or provide reports. The proposed system aims to allow easier viewing and updating of information. It keeps electronic transaction records to save time, energy and money. The system conclusion is that it is beneficial for data accuracy, security, access and usage. It meets its goals of simplifying operations, reducing manual work and data issues, and providing a user-friendly and secure system.
The document describes an OOP project for a bus reservation system created by Hussnain Khan, Sannan Ahmed Gulzar. It lists the requirements, including gathering information, following teacher rules, and reviewing external sources. It describes the system requirements as a PC with core 2 duo or higher, 512MB RAM, and 180GB hard disk running Windows 7 or 10 with Dev C++. It outlines the key classes and functions for the front end, dates, places, display, title, menu, and exit. It details installing bus details, allotting seats, showing empty seats, and displaying available seats. It provides examples of bus stations in Islamabad. It outlines the output including an intro screen, installing buses, selecting
Software (requirement) analysis using umlDhiraj Shetty
The document discusses software requirement analysis for a hotel management system using UML. It describes creating requirement artifacts like use case models, class diagrams, sequence diagrams and activity diagrams. The use case model identifies key actors and elaborates use case scenarios for room reservation, room service, telephone service and billing. The document prioritizes top use cases and provides detailed use case specifications for making a reservation, corporate reservation and group reservation.
This document summarizes a student's term paper on an object-oriented programming course project involving a railway reservation system developed in C++. The paper includes sections on the proposed system, system development life cycle, source code, testing, data flow diagram, advantages, and hardware/software requirements. Key aspects of the railway reservation system project include using object-oriented programming principles in C++ and following standard phases of the system development life cycle.
This document discusses SQL and relational database management systems. It provides definitions of SQL, DML, DDL, and DCL. Common SQL commands like select, delete, update, and insert are listed. The differences between database management systems and relational database management systems are explained. Examples of database systems like Microsoft Access and SQL Server are provided. Finally, some sample tables for a library database are shown, along with recommendations to computerize the library's customer service and use RFID chips and access restrictions for security.
This document describes using UML diagrams to model the basic processes of a restaurant, including a customer entering and ordering food, the food being cooked and served, and the customer paying. It outlines class, use case, sequence, and state machine diagrams to illustrate a customer moving through the restaurant process from initial entry to final payment.
Synopsis for Online Railway Railway Reservation SystemZainabNoorGul
This document proposes an online railway management system to reduce paperwork, improve efficiency and provide online services. It aims to automate reservation status, provide online payment and a user-friendly interface for administrators, reservation counters and passengers. The system will use Visual Studio, SQL Server, ASP.NET, C#, HTML, CSS and JavaScript. It is estimated to take 15 weeks to implement through requirements analysis, design, coding, testing and implementation phases.
This document summarizes a hotel management system developed by a group of students under faculty guidance. The system was designed according to hotel industry needs and ensures efficient operation. It allows staff to computerize customer transactions and record bookings to reduce errors. The user-friendly system provides benefits like reduced time/paperwork and room availability checks. However, power outages can cause inconvenience and the system is vulnerable to viruses. Required hardware includes computers, printers, and software like Oracle and SQL. Potential enhancements involve online payments and bookings. Developing the project provided the student experience in managing projects.
This document outlines a hotel management system project that was developed using Visual Studio 2010 and SQL Server 2008. It includes an introduction describing the system's reservation management capabilities. Sections then cover the problem statement, system environment, network diagram, requirement analysis, data flow diagrams, entity relationship diagram, proposed user interface, testing plan, and implementation plan. The implementation plan specifies hardware, software, and network requirements including Windows, Visual Studio 2015, SQL Server 2012, and ASP.NET for developing a dynamic website.
Presentation1 project report on apartment management systemnitesh kumar sahu
This document describes a proposed software application called the "Apartment Management System" to help construction companies manage apartments and monthly maintenance expenses. The software would handle requests from apartment owners, track monthly expenses for each apartment, generate billing details, and maintain hardware records. It aims to simplify the manual record keeping process which is time-consuming and prone to errors. The proposed system includes administrator and user modules to manage apartment details, allotments, receipts, maintenance, and generate reports.
This S.R.S deals with the basic's of hotel management system.It will show different features with different functionalities.Data Flow diagram is also mentioned With 0 and 1 Level diagram.
This document provides an overview of a proposed hotel management system project. The system will automate key hotel processes like room activities, check-ins, check-outs, room assignments, and billing. It aims to provide an efficient, fast, and user-friendly system. Customers will be able to reserve rooms, view hotel information and galleries online from anywhere. The administrative staff will be able to keep records of customers and daily operations in a database. The system requirements include a computer with at least 512MB RAM, monitor, keyboard, mouse, an operating system like Windows or Linux, a web server like WAMP, and a web browser.
1) Three students are proposing a hotel management system project to computerize the manual record keeping process of a hotel and improve efficiency.
2) Currently the hotel uses a file-based system to manage guest details, bills, inventory, etc. which is time-consuming and error-prone. The proposed system aims to address these issues.
3) The project will develop a fully functional computerized system to streamline key hotel operations like room management, guest check-in/out, billing, and reporting. This will allow staff to complete tasks more quickly and easily.
This document outlines the development of a hotel management system, including an overview of the organization and need for the project. It describes the current manual system and proposed automated system to address drawbacks like data loss and inefficiency. Hardware and software requirements are specified, along with details of testing strategies like unit, system, functional, and integration testing. Data flow diagrams and form and code layouts are provided for key system functions like sign up, menu, customer information, reservations, and viewing records. Future enhancements are suggested around parking, expenses, utilities, and tracking income.
The document provides a software requirement specification for an online railway reservation system called Reserve-All. It outlines the following key points:
1. The system will provide features for user registration and login, train and seat availability inquiries, ticket booking including Tatkal tickets, cancellation and refund facilities, and transaction history.
2. The admin requirements include user database management, payment management, and syncing with the official railway reservation system.
3. The user needs basic computer and internet knowledge. The system requires a secure internet connection and Java-enabled browser.
4. The performance goals are a response time of around 2 seconds and handling over 1,000 concurrent users. Security and fault tolerance are also design constraints.
Presentation Of E canteen System that provide interactive interface to order food items and variuos operation to make interface attractive and easy to use.
This document presents a proposal for developing a computerized reservation system for Hotel Oak-Ray Kandy to replace their current manual system. The objectives are to save time, provide quick service for guests, and develop databases to store guest details. The current manual system requires significant effort for file security and storage. The proposed system will use a waterfall development methodology and include features like guest registration, room booking, and reservation confirmation online or by phone. It will follow design documentation practices like a context diagram, data flow diagram, use case diagram, ER diagram, and interface prototypes. The system requirements specify needed hardware, software, and security considerations.
Zaycoland Resort and Hotel Online Management SystemJason Castellano
The Zaycoland Resort and Hotel Online Management System is a web-based platform that automates and simplifies the hotel's daily operations, allowing guests to make reservations, manage bookings, and access information online. It features two modules - the Guest and Admin modules - that provide real-time access to data, enabling managers to monitor room occupancy, sales performance, and customer satisfaction levels. The system streamlines guest management and improves the overall guest experience.
This document describes a hotel management system created for Dayal Hotel. It discusses the development process using an iterative waterfall model and object-oriented coding. The system was meant to automate key hotel operations like reservations, room management, inventory, and administration. It provides details on the hardware, software, database interfaces and features like user login, guest management, and payment processing. Performance requirements, assumptions, and entity relationship diagrams are also included. In conclusion, it states that hotel management systems provide advantages of modernization and make management work easier through automated reports.
This document summarizes a project on a hostel management system. It was created by three students and supervised by Nahid Anwar. The project aims to develop a computerized system to more efficiently manage activities at a hostel, avoiding problems of manual record keeping. It will allow administrators to view student profiles, allocate rooms, track payments, and update records. The project follows a waterfall model approach and will analyze requirements, design interfaces and databases, implement features, test the system, and support ongoing maintenance.
This document describes an apartment management system project. The system allows apartment owners to register tenants online rather than using physical registers. It allows administrators to view owner and tenant details. The system manages tenant information and rent payment records. It was developed to more easily organize apartment details, as the previous manual system could not view single user information or provide reports. The proposed system aims to allow easier viewing and updating of information. It keeps electronic transaction records to save time, energy and money. The system conclusion is that it is beneficial for data accuracy, security, access and usage. It meets its goals of simplifying operations, reducing manual work and data issues, and providing a user-friendly and secure system.
The document describes an OOP project for a bus reservation system created by Hussnain Khan, Sannan Ahmed Gulzar. It lists the requirements, including gathering information, following teacher rules, and reviewing external sources. It describes the system requirements as a PC with core 2 duo or higher, 512MB RAM, and 180GB hard disk running Windows 7 or 10 with Dev C++. It outlines the key classes and functions for the front end, dates, places, display, title, menu, and exit. It details installing bus details, allotting seats, showing empty seats, and displaying available seats. It provides examples of bus stations in Islamabad. It outlines the output including an intro screen, installing buses, selecting
Software (requirement) analysis using umlDhiraj Shetty
The document discusses software requirement analysis for a hotel management system using UML. It describes creating requirement artifacts like use case models, class diagrams, sequence diagrams and activity diagrams. The use case model identifies key actors and elaborates use case scenarios for room reservation, room service, telephone service and billing. The document prioritizes top use cases and provides detailed use case specifications for making a reservation, corporate reservation and group reservation.
This document summarizes a student's term paper on an object-oriented programming course project involving a railway reservation system developed in C++. The paper includes sections on the proposed system, system development life cycle, source code, testing, data flow diagram, advantages, and hardware/software requirements. Key aspects of the railway reservation system project include using object-oriented programming principles in C++ and following standard phases of the system development life cycle.
This document discusses SQL and relational database management systems. It provides definitions of SQL, DML, DDL, and DCL. Common SQL commands like select, delete, update, and insert are listed. The differences between database management systems and relational database management systems are explained. Examples of database systems like Microsoft Access and SQL Server are provided. Finally, some sample tables for a library database are shown, along with recommendations to computerize the library's customer service and use RFID chips and access restrictions for security.
This document describes using UML diagrams to model the basic processes of a restaurant, including a customer entering and ordering food, the food being cooked and served, and the customer paying. It outlines class, use case, sequence, and state machine diagrams to illustrate a customer moving through the restaurant process from initial entry to final payment.
Synopsis for Online Railway Railway Reservation SystemZainabNoorGul
This document proposes an online railway management system to reduce paperwork, improve efficiency and provide online services. It aims to automate reservation status, provide online payment and a user-friendly interface for administrators, reservation counters and passengers. The system will use Visual Studio, SQL Server, ASP.NET, C#, HTML, CSS and JavaScript. It is estimated to take 15 weeks to implement through requirements analysis, design, coding, testing and implementation phases.
This document summarizes a hotel management system developed by a group of students under faculty guidance. The system was designed according to hotel industry needs and ensures efficient operation. It allows staff to computerize customer transactions and record bookings to reduce errors. The user-friendly system provides benefits like reduced time/paperwork and room availability checks. However, power outages can cause inconvenience and the system is vulnerable to viruses. Required hardware includes computers, printers, and software like Oracle and SQL. Potential enhancements involve online payments and bookings. Developing the project provided the student experience in managing projects.
This document outlines a hotel management system project that was developed using Visual Studio 2010 and SQL Server 2008. It includes an introduction describing the system's reservation management capabilities. Sections then cover the problem statement, system environment, network diagram, requirement analysis, data flow diagrams, entity relationship diagram, proposed user interface, testing plan, and implementation plan. The implementation plan specifies hardware, software, and network requirements including Windows, Visual Studio 2015, SQL Server 2012, and ASP.NET for developing a dynamic website.
Presentation1 project report on apartment management systemnitesh kumar sahu
This document describes a proposed software application called the "Apartment Management System" to help construction companies manage apartments and monthly maintenance expenses. The software would handle requests from apartment owners, track monthly expenses for each apartment, generate billing details, and maintain hardware records. It aims to simplify the manual record keeping process which is time-consuming and prone to errors. The proposed system includes administrator and user modules to manage apartment details, allotments, receipts, maintenance, and generate reports.
This S.R.S deals with the basic's of hotel management system.It will show different features with different functionalities.Data Flow diagram is also mentioned With 0 and 1 Level diagram.
This document provides an overview of a proposed hotel management system project. The system will automate key hotel processes like room activities, check-ins, check-outs, room assignments, and billing. It aims to provide an efficient, fast, and user-friendly system. Customers will be able to reserve rooms, view hotel information and galleries online from anywhere. The administrative staff will be able to keep records of customers and daily operations in a database. The system requirements include a computer with at least 512MB RAM, monitor, keyboard, mouse, an operating system like Windows or Linux, a web server like WAMP, and a web browser.
1) Three students are proposing a hotel management system project to computerize the manual record keeping process of a hotel and improve efficiency.
2) Currently the hotel uses a file-based system to manage guest details, bills, inventory, etc. which is time-consuming and error-prone. The proposed system aims to address these issues.
3) The project will develop a fully functional computerized system to streamline key hotel operations like room management, guest check-in/out, billing, and reporting. This will allow staff to complete tasks more quickly and easily.
This document outlines the development of a hotel management system, including an overview of the organization and need for the project. It describes the current manual system and proposed automated system to address drawbacks like data loss and inefficiency. Hardware and software requirements are specified, along with details of testing strategies like unit, system, functional, and integration testing. Data flow diagrams and form and code layouts are provided for key system functions like sign up, menu, customer information, reservations, and viewing records. Future enhancements are suggested around parking, expenses, utilities, and tracking income.
The document provides a software requirement specification for an online railway reservation system called Reserve-All. It outlines the following key points:
1. The system will provide features for user registration and login, train and seat availability inquiries, ticket booking including Tatkal tickets, cancellation and refund facilities, and transaction history.
2. The admin requirements include user database management, payment management, and syncing with the official railway reservation system.
3. The user needs basic computer and internet knowledge. The system requires a secure internet connection and Java-enabled browser.
4. The performance goals are a response time of around 2 seconds and handling over 1,000 concurrent users. Security and fault tolerance are also design constraints.
Presentation Of E canteen System that provide interactive interface to order food items and variuos operation to make interface attractive and easy to use.
This document presents a proposal for developing a computerized reservation system for Hotel Oak-Ray Kandy to replace their current manual system. The objectives are to save time, provide quick service for guests, and develop databases to store guest details. The current manual system requires significant effort for file security and storage. The proposed system will use a waterfall development methodology and include features like guest registration, room booking, and reservation confirmation online or by phone. It will follow design documentation practices like a context diagram, data flow diagram, use case diagram, ER diagram, and interface prototypes. The system requirements specify needed hardware, software, and security considerations.
Zaycoland Resort and Hotel Online Management SystemJason Castellano
The Zaycoland Resort and Hotel Online Management System is a web-based platform that automates and simplifies the hotel's daily operations, allowing guests to make reservations, manage bookings, and access information online. It features two modules - the Guest and Admin modules - that provide real-time access to data, enabling managers to monitor room occupancy, sales performance, and customer satisfaction levels. The system streamlines guest management and improves the overall guest experience.
This document describes a hotel management system created for Dayal Hotel. It discusses the development process using an iterative waterfall model and object-oriented coding. The system was meant to automate key hotel operations like reservations, room management, inventory, and administration. It provides details on the hardware, software, database interfaces and features like user login, guest management, and payment processing. Performance requirements, assumptions, and entity relationship diagrams are also included. In conclusion, it states that hotel management systems provide advantages of modernization and make management work easier through automated reports.
Hotel Booking Management System PHP.pptxriohaven45
This document describes a hotel management system created to automate an existing manual hotel booking and management process. The system was created using PHP and MySQL to store booking, client, and hotel service data. It includes modules for users to book rooms, view services and galleries, and manage their accounts. Admin modules allow managing room categories and listings, bookings, registered users, inquiries and reports. The objectives are to reduce time/costs of the manual system and properly manage user and service details. It aims to eliminate issues of the outdated manual process through a computerized and easy-to-use system.
This document provides details about a student's computer science investigatory project on a hotel management system. It includes sections like the certificate, acknowledgement, synopsis, system requirements, introduction, existing system, proposed system, and about Python and MySQL. The project uses Python programming language to develop a simple console-based hotel management system that allows users to enter their details, calculate room rent and bills, and view their total cost of staying. It aims to provide a single platform for basic hotel operations and management of services and transactions.
This document provides an overview of a student group's online hotel management system project. It introduces the project topic and group members. It then describes the existing manual hotel management system and its limitations. The proposed system aims to automate the process and address the issues with the current system by developing a computerized system accessible online to customers and administrators. It outlines the scope, objectives and proposed solution involving centralizing records in a database and making the system available 24/7 online. It also discusses the methodology using SDLC, includes diagrams of the work breakdown structure, data flow and entity relationships.
This document provides a software requirements specification for an online room booking system. It includes sections that describe the purpose and scope of the system, user interfaces, system features, and other requirements. The system will allow customers to reserve hotel rooms online and manage reservations. It defines requirements for functions like viewing room details, booking rooms, and administrative management. Non-functional requirements around performance, security, and software quality are also specified.
This document provides a system analysis and design report for a Hotel Management System. It includes sections on the current manual system and its disadvantages, the proposed automated system and its advantages. It covers feasibility analysis including technical, behavioral and economic feasibility. It also includes system design elements like data flow diagrams, entity relationship diagrams and database tables. The document provides an overview of how the system will be implemented and tested.
The document describes an online hotel management system created by a group of 6 students. It discusses the disadvantages of the existing manual hotel booking system, such as being time-consuming and prone to errors. The proposed online system would allow customers to book rooms and check availability anytime from the internet. It would also help hotel management keep digital records and see daily income reports. The system has modules for users to make bookings and administrators to manage reservations and view analytics.
The document discusses a hotel management system that allows users to make online reservations, check room availability, and perform other functions like check-in, billing, and reporting. It provides an introduction to hotel management systems and their benefits. Entity relationship and data flow diagrams are presented to illustrate the system design. Advantages include time savings for users and the hotel. The conclusion notes that the project was designed to meet online hotel management needs using system analysis techniques.
The document discusses a hotel management system that allows users to make online reservations, check room availability, and manage other aspects of running a hotel. It provides an introduction to hotel management systems and their benefits. Entity relationship and data flow diagrams are presented to illustrate how the system manages bookings and room openings. Advantages include time savings for users and the hotel. The conclusion discusses how the project meets online hotel management needs using system design techniques.
The document discusses a hotel management system that allows users to make online reservations, check room availability, and perform other functions like check-in, billing, and reporting. It provides an introduction to hotel management systems and their benefits. Entity relationship and data flow diagrams are presented to illustrate the system design. Advantages include time savings for users and the hotel. The conclusion notes that the project was designed to meet online hotel management needs using system analysis techniques.
Limman’s Center Inn Online Reservation and Billing SystemJason Castellano
The Inn industry is a business venture for the owner and a solace for the traveler and/or tourist. A customer can get stranded in the quest to secure a room to pass the night if he has not made adequate plans by the existing system. Through this study, it was realized that for a customer to be guaranteed a room, he or she has to physically come to the inn since the attendants paid more attention to that. He could also send a friend or relative who lives around the neighborhood of the inn to do the booking for him. There is nothing to bond the inn and the customer in person that he has indeed booked for a room. This study took Limman’s Center Inn as its case. It looked at creating an online reservation system to enable customers choose the room they wanted after a virtual tour to guarantee him a room.
The document proposes a web-based venue booking management system that allows users to search for and book wedding halls online. The existing manual system is inefficient as it is difficult to track booking records and update customer details. The proposed system would allow customers to book, modify, and cancel bookings online. It would also display venue information and photos. Administrators could easily edit booking information. The system would use an agile methodology and require HTML, CSS, JavaScript, PHP, and a MySQL database. It would provide a more efficient and user-friendly platform for managing venue bookings online.
Sigma Infosolutions developed an outbound reservation management system for a client using J2EE technologies. The system allows users to monitor, analyze, manage, and report on business performance and reservations across multiple properties. It expedites the handling of customer inquiries and eliminated redundant reporting tasks. The system improved follow-up procedures, reduced effort to track inquiries, and provided management with detailed sales data analysis tools.
Hotel management systems (HMS) are software applications designed to streamline and automate various operations in a hotel. They cover key areas like guest management, inventory management, financial management, and operations management. HMS provide benefits like increased efficiency, improved guest experience, enhanced data accuracy, and cost savings. A basic HMS could consist of modules for guest management, room management, booking engine, payment processing, and reporting. Existing HMS solutions range from simple, single-function booking systems to comprehensive enterprise-level platforms and may have limitations regarding cost, complexity, flexibility, and data security.
eZee FrontDesk is a state-of-art property management system that enables hotels and hotel chains to run business operations more efficiently and effectively. Designed and developed with latest technology meeting international hospitality standards.
Web application for booking paying guest & explore mess and stationary in the...IRJET Journal
The document proposes a web application that integrates paying guest bookings, food options, and stationary shops into a single platform, allowing users to complete all rental accommodation and daily activity needs in one place. Currently, discrete applications exist for booking rooms, finding restaurants, etc. but lack integration. The proposed application aims to address this by allowing users to search for accommodations, nearby food zones, and stationary shops all based on their location input.
This document describes a flight booking system created using Java Spring Boot, JSP, CSS3, and Bootstrap. The system allows customers to check flight availability and book seats. It has modules for administration, receptionists, and customers. The admin module allows managing users, bookings, and reports. Receptionists can view bookings and register customers. Customers can search for flights, make reservations, and view their accounts. The system was implemented using a Java Spring Boot backend with JSP for the frontend. It provides a web-based solution for managing flight bookings and seats.
Decolonizing Universal Design for LearningFrederic Fovet
UDL has gained in popularity over the last decade both in the K-12 and the post-secondary sectors. The usefulness of UDL to create inclusive learning experiences for the full array of diverse learners has been well documented in the literature, and there is now increasing scholarship examining the process of integrating UDL strategically across organisations. One concern, however, remains under-reported and under-researched. Much of the scholarship on UDL ironically remains while and Eurocentric. Even if UDL, as a discourse, considers the decolonization of the curriculum, it is abundantly clear that the research and advocacy related to UDL originates almost exclusively from the Global North and from a Euro-Caucasian authorship. It is argued that it is high time for the way UDL has been monopolized by Global North scholars and practitioners to be challenged. Voices discussing and framing UDL, from the Global South and Indigenous communities, must be amplified and showcased in order to rectify this glaring imbalance and contradiction.
This session represents an opportunity for the author to reflect on a volume he has just finished editing entitled Decolonizing UDL and to highlight and share insights into the key innovations, promising practices, and calls for change, originating from the Global South and Indigenous Communities, that have woven the canvas of this book. The session seeks to create a space for critical dialogue, for the challenging of existing power dynamics within the UDL scholarship, and for the emergence of transformative voices from underrepresented communities. The workshop will use the UDL principles scrupulously to engage participants in diverse ways (challenging single story approaches to the narrative that surrounds UDL implementation) , as well as offer multiple means of action and expression for them to gain ownership over the key themes and concerns of the session (by encouraging a broad range of interventions, contributions, and stances).
How to Create a Stage or a Pipeline in Odoo 17 CRMCeline George
Using CRM module, we can manage and keep track of all new leads and opportunities in one location. It helps to manage your sales pipeline with customizable stages. In this slide let’s discuss how to create a stage or pipeline inside the CRM module in odoo 17.
8+8+8 Rule Of Time Management For Better ProductivityRuchiRathor2
This is a great way to be more productive but a few things to
Keep in mind:
- The 8+8+8 rule offers a general guideline. You may need to adjust the schedule depending on your individual needs and commitments.
- Some days may require more work or less sleep, demanding flexibility in your approach.
- The key is to be mindful of your time allocation and strive for a healthy balance across the three categories.
The Science of Learning: implications for modern teachingDerek Wenmoth
Keynote presentation to the Educational Leaders hui Kōkiritia Marautanga held in Auckland on 26 June 2024. Provides a high level overview of the history and development of the science of learning, and implications for the design of learning in our modern schools and classrooms.
How to Create User Notification in Odoo 17Celine George
This slide will represent how to create user notification in Odoo 17. Odoo allows us to create and send custom notifications on some events or actions. We have different types of notification such as sticky notification, rainbow man effect, alert and raise exception warning or validation.
Artificial Intelligence (AI) has revolutionized the creation of images and videos, enabling the generation of highly realistic and imaginative visual content. Utilizing advanced techniques like Generative Adversarial Networks (GANs) and neural style transfer, AI can transform simple sketches into detailed artwork or blend various styles into unique visual masterpieces. GANs, in particular, function by pitting two neural networks against each other, resulting in the production of remarkably lifelike images. AI's ability to analyze and learn from vast datasets allows it to create visuals that not only mimic human creativity but also push the boundaries of artistic expression, making it a powerful tool in digital media and entertainment industries.
Creativity for Innovation and SpeechmakingMattVassar1
Tapping into the creative side of your brain to come up with truly innovative approaches. These strategies are based on original research from Stanford University lecturer Matt Vassar, where he discusses how you can use them to come up with truly innovative solutions, regardless of whether you're using to come up with a creative and memorable angle for a business pitch--or if you're coming up with business or technical innovations.
1. HOTEL MANAGEMENT SYSTEM
Dissertation submitted in fulfilment of the requirements for the Degree of
BACHELOR OF TECHNOLOGY
in
COMPUTER SCIENCE AND ENGINEERING
By
SEHAJ KOUR RAINA
12106382
Supervisor
JAN PREET SINGH
School of Computer Science and Engineering
Lovely Professional University
Phagwara, Punjab (India)
Month - November Year - 2022
@ Copyright LOVELY PROFESSIONAL UNIVERSITY, Punjab (INDIA)
Month - November, Year - 2022
ALL RIGHTS RESERVED
2. ABSTRACT
This project aims to develop a Hotel Management System. A Hotel
Management System can be used in any hotel across the world. In this project I
design E-R diagram for Hotel Management System, then I describe about
different entities and their attributes, then relationship between entities,
relational schemas, normalization, sql implementation and pl/sql, then I
concluded my work followed by future work.
I simply used YouTube to get knowledge about schemas, entities, attributes,
normalization, etc. I use google to find template of the hotel management
system in DBMS.
Hotel Management project provides room booking, staff management and
other necessary hotel management features. The system allows the manager
to post available rooms in the system. Customers can view and book room
online. Admin has the power of either approving or disapproving the
customer's booking request. Other hotel services can also be viewed by the
customers and can book them too. The system is hence useful for both
customers and managers to portably manage the hotel activities.
The system aims at the maintenance and management of the different Hotels
that are available in the different parts of the world. It mainly takes care of the
Hotel management at the core area of the database. The system provides the
information regarding the different Hotels that are available and their status
specific to availability. The guests can visit the site and register themselves
with the required information that is expected by the system. Each registered
guest can raise a request for the unit bookings. The Guests are scheduled with
the information of the availability of the units for they have requested the
time.
3. INTRODUCTION
The entire project has been developed keeping in view of the Distributed client
server computing technology in mind. The specification has been normalized
up to 3NF to eliminate all the anomalies that may arise due to the database
transactions that are executed by the actual administration and users. The user
interfaces are browser specific to give distributed accessibility for the overall
system. The basic constructs of the tablespaces, clusters and indexes have
been exploited to provide higher consistency and reliability for the data
storage.
Hotel Management System is a system that provides us to reserving rooms,
checking whether the rooms are vacant are or not etc by using online
browsing. This system is very useful to all especially for businesspeople. For
Businesspeople they don’t have sufficient time for these then they can use
these types of online Hotel Management Systems. By this project we will
reduce the faults in bills of their expenditure and decrease time of delay to
give the bills to the customers. We can also save the bills of the customer. By
this project we can also include all the taxes on the bills according to their
expenditures. It has a scope to reduce the errors in making the bills.
Computerized bill can be printed within fraction of seconds. Online ordering of
Booking is possible by using this software. This Project is based on php. If
anyone wants to book the room for few days, then they can specify the specific
number by seeing the types of rooms we have. The bill of this online booking is
based on the type of room they can select is displayed. HOTEL MANAGEMENT
SYSTEM is a hotel reservation site script where site users will be able to search
rooms availability with an online booking reservations system. Site users can
also browse hotels, view room inventory, check availability, and book
reservations in real-time. Site users enter check in date and check out date
then search for availability and rates. After choosing the right room in the
wanted hotel – all booking and reservation process is done on the site and an
SMS is sent to confirm the booking.
4. Purpose:
The purpose of hotel booking system is to automate the existing manual
system by the help of computerized equipment’s and full-fledged computer
software, fulfilling their requirement, so that their valuable or information can
be stored for a longer period with easy accessing and manipulating of the
same. The required software and hardware are easily available and easy to
work with. This proposes that efficiency of hotel organizations could be
improved by integrating service-oriented operations service-oriented
operations with project management principles. Such integration would install
innovation, proactive attitudes and regulated risk-taking needed to pursue
ongoing improvement and proactive response to change. By managing each
change as a project, embedded in smoothly running operations, hotels would
extend their life span by continuously reinventing themselves
The main objective of this project is to create a database management system
for a hotel. The hotel can have multiple chains, which can further have multiple
hotels. Therefore, we need an organized management system, which can easily
manage all the operations and data of the hotel chains and hotels respectively.
We will be managing the below areas of the hotel database management
system.
Scope
In this step, we provide a detailed description about the existing system and
the problems faced in the existing system. This stage there is no existing
system previously; we are developing a new system. Till now no system is
available with this type of features and facilities. This system is developed for
all types of users with highly flexible and configurable product is envisaged to
ensure global marketing.
6. INFORMATION OF ENTITIES
1. Customer:
(Attributes – S SN, Country, Name, Email)
The customer is the person who books hotel rooms to stay for some
time, on booking hotel customer gets a booking id (S SN) is generated
and used as primary key to identify the Customer information.
2. Today price:
(Attributes – hotel_id, price, available_rooms, date)
Today price fetch the price of today’s hotel rooms & show it to the
customer. Here hotel_id is used as primary key for this table.
3. Rooms_categoy:
(Attributes – name, cus_id, hotel_id)
Rooms category fetch types of rooms available for particular hotel. Here
hotel_id is foreign key referencing the hotel_id from today price entity.
4. Hotel:
(Attributes – name, location, hotel_id)
Hotel gets the record of all hotels in particular area. Here hotel_id is used
as primary key to get the information from this table.
5. Invoice:
(Attributes – invoice_id, status, invoice_description)
Here invoice table store the records of invoice generated after the
payment is done by the customer. Here invoice_id is used as primary key
to get the information from this table.
6. Bill:
(Attributes – bill_id, amounts, name, type, date)
Here this table stores the record of all bills of customers. Here bill_id is
foreign key referencing the invoice_id from the invoice entity.
7. RELATIONAL SCHEMAS
Customer Table:
1. The relationship with Today price and Customer is one to many.
2. The relationship with Rooms and Customer is also one to many.
3. Relationship with Invoice and Customer is also one to many.
Hotel Table:
1. The relationship with Customer and Hotel is many to one because one
customer can book many rooms at a time.
Invoice Table:
1. The relationship with Customer and Invoice is many to one because one
customer can have many invoices.
2. The relationship with Bill and Invoice is one to many because one invoice
can contain bills of many services.
Bill:
1. The relationship with Invoice and Bill is many to one because many bills
can be connected to a single Invoice.
Today price:
1. The relationship with Customer and Today price is many to one because
one customer can book rooms of different prices in same day and then
he has to check the today price table
2. The relationship with Rooms category and Today price is one to many
because many rooms can have same price.
8. Rooms category:
1. The relationship with Today price and rooms category is many to one
because many rooms category can have same price.
NORMALIZATION
Normalization Rule
Normalization rules are divided into the following normal forms:
1. First Normal Form
2. Second Normal Form
3. Third Normal Form
First Normal Form (1NF)
For a table to be in the First Normal Form, it should follow the following 4
rules:
1. It should only have single (atomic) valued attributes/columns.
2. Values stored in a column should be of the same domain.
3. All the columns in a table should have unique names.
4. And the order in which data is stored, does not matter.
Second Normal Form (2NF)
For a table to be in the Second Normal Form,
1. It should be in the First Normal form.
2. And, it should not have Partial Dependency.
Third Normal Form (3NF)
A table is said to be in the Third Normal Form when,
9. 1. It is in the Second Normal form.
2. And, it doesn't have Transitive Dependency.
10. PL/SQL
CREATING HOTEL DATABASE
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- Schema hotel_database
-- Schema hotel_database
CREATE SCHEMA IF NOT EXISTS `hotel_database` DEFAULT CHARACTER SET utf8 ;
USE `hotel_database` ;
-- Table `hotel_database`.`addresses`
DROP TABLE IF EXISTS `hotel_database`.`addresses` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`addresses` (
`address_id` INT NOT NULL,
`address_line1` VARCHAR(100) NULL,
`address_line2` VARCHAR(100) NULL,
`city` VARCHAR(45) NULL,
`state` VARCHAR(45) NULL,
`country` VARCHAR(45) NULL,
11. `zipcode` VARCHAR(8) NULL,
PRIMARY KEY (`address_id`))
ENGINE = InnoDB;
-- Table `hotel_database`.`hotel_chain`
DROP TABLE IF EXISTS `hotel_database`.`hotel_chain` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`hotel_chain` (
`hotel_chain_id` INT NOT NULL,
`hotel_chain_name` VARCHAR(45) NULL,
`hotel_chain_contact_number` VARCHAR(12) NULL,
`hotel_chain_email_address` VARCHAR(45) NULL,
`hotel_chain_website` VARCHAR(45) NULL,
`hotel_chain_head_office_address_id` INT NOT NULL,
PRIMARY KEY (`hotel_chain_id`, `hotel_chain_head_office_address_id`),
CONSTRAINT `fk_hotel_chains_addresses1`
FOREIGN KEY (`hotel_chain_head_office_address_id`)
REFERENCES `hotel_database`.`addresses` (`address_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_hotel_chains_addresses1_idx` ON `hotel_database`.`hotel_chain`
(`hotel_chain_head_office_address_id` ASC);
12. -- Table `hotel_database`.`star_ratings`
DROP TABLE IF EXISTS `hotel_database`.`star_ratings` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`star_ratings` (
`star_rating` INT NOT NULL,
`star_rating_image` VARCHAR(100) NULL,
PRIMARY KEY (`star_rating`))
ENGINE = InnoDB;
-- Table `hotel_database`.`hotel`
DROP TABLE IF EXISTS `hotel_database`.`hotel` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`hotel` (
`hotel_id` INT NOT NULL,
`hotel_name` VARCHAR(45) NULL,
`hotel_contact_number` VARCHAR(12) NULL,
`hotel_email_address` VARCHAR(45) NULL,
`hotel_website` VARCHAR(45) NULL,
`hotel_description` VARCHAR(100) NULL,
`hotel_floor_count` INT NULL,
`hotel_room_capacity` INT NULL,
`hotel_chain_id` INT NULL,
`addresses_address_id` INT NOT NULL,
`star_ratings_star_rating` INT NOT NULL,
`check_in_time` TIME NULL,
13. `check_out_time` TIME NULL,
PRIMARY KEY (`hotel_id`, `addresses_address_id`, `star_ratings_star_rating`),
CONSTRAINT `fk_hotels_addresses1`
FOREIGN KEY (`addresses_address_id`)
REFERENCES `hotel_database`.`addresses` (`address_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_hotel_star_ratings1`
FOREIGN KEY (`star_ratings_star_rating`)
REFERENCES `hotel_database`.`star_ratings` (`star_rating`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = ' ';
CREATE INDEX `fk_hotels_addresses1_idx` ON `hotel_database`.`hotel`
(`addresses_address_id` ASC);
CREATE INDEX `fk_hotel_star_ratings1_idx` ON `hotel_database`.`hotel`
(`star_ratings_star_rating` ASC);
-- Table `hotel_database`.`room_type`
DROP TABLE IF EXISTS `hotel_database`.`room_type` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`room_type` (
`room_type_id` INT NOT NULL,
`room_type_name` VARCHAR(45) NULL,
14. `room_cost` DECIMAL(10,2) NULL,
`room_type_description` VARCHAR(100) NULL,
`smoke_friendly` TINYINT(1) NULL,
`pet_friendly` TINYINT(1) NULL,
PRIMARY KEY (`room_type_id`))
ENGINE = InnoDB;
-- Table `hotel_database`.`rooms`
DROP TABLE IF EXISTS `hotel_database`.`rooms` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`rooms` (
`room_id` INT NOT NULL,
`room_number` INT(4) NULL,
`rooms_type_rooms_type_id` INT NOT NULL,
`hotel_hotel_id` INT NOT NULL,
PRIMARY KEY (`room_id`, `rooms_type_rooms_type_id`, `hotel_hotel_id`),
CONSTRAINT `fk_rooms_rooms_type1`
FOREIGN KEY (`rooms_type_rooms_type_id`)
REFERENCES `hotel_database`.`room_type` (`room_type_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_rooms_hotel1`
FOREIGN KEY (`hotel_hotel_id`)
REFERENCES `hotel_database`.`hotel` (`hotel_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
15. ENGINE = InnoDB;
CREATE INDEX `fk_rooms_rooms_type1_idx` ON `hotel_database`.`rooms`
(`rooms_type_rooms_type_id` ASC);
CREATE INDEX `fk_rooms_hotel1_idx` ON `hotel_database`.`rooms` (`hotel_hotel_id` ASC);
-- Table `hotel_database`.`guests`
DROP TABLE IF EXISTS `hotel_database`.`guests` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`guests` (
`guest_id` INT NOT NULL,
`guest_first_name` VARCHAR(45) NULL,
`guest_last_name` VARCHAR(45) NULL,
`guest_contact_number` VARCHAR(12) NULL,
`guest_email_address` VARCHAR(45) NULL,
`guest_credit_card` VARCHAR(45) NULL,
`guest_id_proof` VARCHAR(45) NULL,
`addresses_address_id` INT NOT NULL,
PRIMARY KEY (`guest_id`, `addresses_address_id`),
CONSTRAINT `fk_guests_addresses1`
FOREIGN KEY (`addresses_address_id`)
REFERENCES `hotel_database`.`addresses` (`address_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = ' ';
16. CREATE INDEX `fk_guests_addresses1_idx` ON `hotel_database`.`guests`
(`addresses_address_id` ASC);
-- Table `hotel_database`.`department`
DROP TABLE IF EXISTS `hotel_database`.`department` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`department` (
`department_id` INT NOT NULL,
`department_name` VARCHAR(45) NULL,
`department_description` VARCHAR(100) NULL,
PRIMARY KEY (`department_id`))
ENGINE = InnoDB;
-- Table `hotel_database`.`employees`
DROP TABLE IF EXISTS `hotel_database`.`employees` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`employees` (
`emp_id` INT NOT NULL,
`emp_first_name` VARCHAR(45) NULL,
`emp_last_name` VARCHAR(45) NULL,
`emp_designation` VARCHAR(45) NULL,
`emp_contact_number` VARCHAR(12) NULL,
`emp_email_address` VARCHAR(45) NULL,
17. `department_department_id` INT NOT NULL,
`addresses_address_id` INT NOT NULL,
`hotel_hotel_id` INT NOT NULL,
PRIMARY KEY (`emp_id`, `department_department_id`, `addresses_address_id`,
`hotel_hotel_id`),
CONSTRAINT `fk_employees_services1`
FOREIGN KEY (`department_department_id`)
REFERENCES `hotel_database`.`department` (`department_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_employees_addresses1`
FOREIGN KEY (`addresses_address_id`)
REFERENCES `hotel_database`.`addresses` (`address_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_employees_hotel1`
FOREIGN KEY (`hotel_hotel_id`)
REFERENCES `hotel_database`.`hotel` (`hotel_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_employees_services1_idx` ON `hotel_database`.`employees`
(`department_department_id` ASC);
CREATE INDEX `fk_employees_addresses1_idx` ON `hotel_database`.`employees`
(`addresses_address_id` ASC);
CREATE INDEX `fk_employees_hotel1_idx` ON `hotel_database`.`employees`
(`hotel_hotel_id` ASC);
18. -- Table `hotel_database`.`bookings`
DROP TABLE IF EXISTS `hotel_database`.`bookings` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`bookings` (
`booking_id` INT NOT NULL,
`booking_date` DATETIME NULL,
`duration_of_stay` VARCHAR(10) NULL,
`check_in_date` DATETIME NULL,
`check_out_date` DATETIME NULL,
`booking_payment_type` VARCHAR(45) NULL,
`total_rooms_booked` INT NULL,
`hotel_hotel_id` INT NOT NULL,
`guests_guest_id` INT NOT NULL,
`employees_emp_id` INT NOT NULL,
`total_amount` DECIMAL(10,2) NULL,
PRIMARY KEY (`booking_id`, `hotel_hotel_id`, `guests_guest_id`, `employees_emp_id`),
CONSTRAINT `fk_bookings_hotel1`
FOREIGN KEY (`hotel_hotel_id`)
REFERENCES `hotel_database`.`hotel` (`hotel_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_bookings_guests1`
FOREIGN KEY (`guests_guest_id`)
REFERENCES `hotel_database`.`guests` (`guest_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
19. CONSTRAINT `fk_bookings_employees1`
FOREIGN KEY (`employees_emp_id` )
REFERENCES `hotel_database`.`employees` (`emp_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_bookings_hotel1_idx` ON `hotel_database`.`bookings` (`hotel_hotel_id`
ASC);
CREATE INDEX `fk_bookings_guests1_idx` ON `hotel_database`.`bookings`
(`guests_guest_id` ASC);
CREATE INDEX `fk_bookings_employees1_idx` ON `hotel_database`.`bookings`
(`employees_emp_id` ASC);
-- Table `hotel_database`.`hotel_chain_has_hotel`
DROP TABLE IF EXISTS `hotel_database`.`hotel_chain_has_hotel` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`hotel_chain_has_hotel` (
`hotel_chains_hotel_chain_id` INT NOT NULL,
`hotels_hotel_id` INT NOT NULL,
PRIMARY KEY (`hotel_chains_hotel_chain_id`, `hotels_hotel_id`),
CONSTRAINT `fk_hotel_chains_has_hotels_hotel_chains1`
FOREIGN KEY (`hotel_chains_hotel_chain_id`)
REFERENCES `hotel_database`.`hotel_chain` (`hotel_chain_id` )
20. ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_hotel_chains_has_hotels_hotels1`
FOREIGN KEY (`hotels_hotel_id`)
REFERENCES `hotel_database`.`hotel` (`hotel_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_hotel_chains_has_hotels_hotels1_idx` ON
`hotel_database`.`hotel_chain_has_hotel` (`hotels_hotel_id` ASC);
CREATE INDEX `fk_hotel_chains_has_hotels_hotel_chains1_idx` ON
`hotel_database`.`hotel_chain_has_hotel` (`hotel_chains_hotel_chain_id` ASC);
-- Table `hotel_database`.`room_rate_discount`
DROP TABLE IF EXISTS `hotel_database`.`room_rate_discount` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`room_rate_discount` (
`discount_id` INT NOT NULL,
`discount_rate` DECIMAL(10,2) NULL,
`start_month` TINYINT(1) NULL,
`end_month` TINYINT(1) NULL,
`room_type_room_type_id` INT NOT NULL,
PRIMARY KEY (`discount_id`, `room_type_room_type_id`),
CONSTRAINT `fk_room_rate_discount_room_type1`
FOREIGN KEY (`room_type_room_type_id`)
21. REFERENCES `hotel_database`.`room_type` (`room_type_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_room_rate_discount_room_type1_idx` ON
`hotel_database`.`room_rate_discount` (`room_type_room_type_id` ASC);
-- Table `hotel_database`.`rooms_booked`
DROP TABLE IF EXISTS `hotel_database`.`rooms_booked` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`rooms_booked` (
`rooms_booked_id` INT NOT NULL,
`bookings_booking_id` INT NOT NULL,
`rooms_room_id` INT NOT NULL,
PRIMARY KEY (`rooms_booked_id`, `bookings_booking_id`, `rooms_room_id`),
CONSTRAINT `fk_rooms_booked_bookings1`
FOREIGN KEY (`bookings_booking_id`)
REFERENCES `hotel_database`.`bookings` (`booking_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_rooms_booked_rooms1`
FOREIGN KEY (`rooms_room_id`)
REFERENCES `hotel_database`.`rooms` (`room_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
22. CREATE INDEX `fk_rooms_booked_bookings1_idx` ON `hotel_database`.`rooms_booked`
(`bookings_booking_id` ASC);
CREATE INDEX `fk_rooms_booked_rooms1_idx` ON `hotel_database`.`rooms_booked`
(`rooms_room_id` ASC);
-- Table `hotel_database`.`hotel_services`
DROP TABLE IF EXISTS `hotel_database`.`hotel_services` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`hotel_services` (
`service_id` INT NOT NULL,
`service_name` VARCHAR(45) NULL,
`service_description` VARCHAR(100) NULL,
`service_cost` DECIMAL(10,2) NULL,
`hotel_hotel_id` INT NOT NULL,
PRIMARY KEY (`service_id`, `hotel_hotel_id`),
CONSTRAINT `fk_hotel_services_hotel1`
FOREIGN KEY (`hotel_hotel_id`)
REFERENCES `hotel_database`.`hotel` (`hotel_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_hotel_services_hotel1_idx` ON `hotel_database`.`hotel_services`
(`hotel_hotel_id` ASC);
23. -- Table `hotel_database`.`hotel_services_used_by_guests`
DROP TABLE IF EXISTS `hotel_database`.`hotel_services_used_by_guests` ;
CREATE TABLE IF NOT EXISTS `hotel_database`.`hotel_services_used_by_guests` (
`service_used_id` INT NOT NULL,
`hotel_services_service_id` INT NOT NULL,
`bookings_booking_id` INT NOT NULL,
PRIMARY KEY (`service_used_id`, `hotel_services_service_id`, `bookings_booking_id`),
CONSTRAINT `fk_hotel_services_has_bookings_hotel_services1`
FOREIGN KEY (`hotel_services_service_id`)
REFERENCES `hotel_database`.`hotel_services` (`service_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_hotel_services_has_bookings_bookings1`
FOREIGN KEY (`bookings_booking_id`)
REFERENCES `hotel_database`.`bookings` (`booking_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
CREATE INDEX `fk_hotel_services_has_bookings_bookings1_idx` ON
`hotel_database`.`hotel_services_used_by_guests` (`bookings_booking_id` ASC);
CREATE INDEX `fk_hotel_services_has_bookings_hotel_services1_idx` ON
`hotel_database`.`hotel_services_used_by_guests` (`hotel_services_service_id` ASC);
25. (1,"/images/one_star.jpg"),
(2,"/images/two_star.jpg"),
(3,"/images/three_star.jpg"),
(4,"/images/four_star.jpg"),
(5,"/images/five_star.jpg");
INSERT INTO `department`(`department_id`, `department_name`,
`department_description`)
VALUES
(1,'Kitchen','cooking'),
(2,'Cleaning','sweep and mop'),
(3,'Front Staff','handle bookings and query resolution'),
(4,'Management','handles customer and resolve complaints'),
(5,'Commute','pick up and drop');
INSERT INTO `room_type`(`room_type_id`, `room_type_name`, `room_cost`,
`room_type_description`, `smoke_friendly`, `pet_friendly`)
VALUES
(1, 'Standard Room','103',"1 King Bed 323-sq-foot (30-sq-meter) room with city
views",0,1),
(2, 'Standard Twin Room','123',"Two Twin Bed 323-sq-foot (30-sq-meter) room with
city views",1,1),
(3, 'Executive Room','130',"1 King Bed 323-sq-foot (30-sq-meter) room with city
views",0,0),
(4, 'Club Room','159',"2 King Bed 323-sq-foot (30-sq-meter) room with city
views",1,1);
INSERT INTO `guests`(`guest_id`, `guest_first_name`, `guest_last_name`,
`guest_contact_number`, `guest_email_address`, `guest_credit_card`, `guest_id_proof`,
`addresses_address_id`)
VALUES
29. (32,1132,2,1),
(33,1133,2,1),
(34,1134,2,1),
(35,1135,2,1);
INSERT INTO `hotel_services`(`service_id`, `service_name`, `service_description`,
`service_cost`, `hotel_hotel_id`)
VALUES
(1,'24-hour Room Service','There will be 24-hour Room Service to take care of
customers needs',20,1),
(2,'Currency Exchange','Foreign Currency Exchange facility available',80,1),
(3,'Laundry','Laundry/Dry Cleaning available same day',10,1),
(4,'Entertainment Room','Book and watch movies',50,2),
(5,'Swimming Pool','Pool access to all the guests',100,2),
(6,'Gym','24 Hour Gym',140,2);
INSERT INTO `employees`(`emp_id`, `emp_first_name`, `emp_last_name`,
`emp_designation`, `emp_contact_number`, `emp_email_address`,
`department_department_id`, `addresses_address_id`, `hotel_hotel_id`)
VALUES
(1,'Jen','Fen','Waiter','123-789-7896','jen.rds@gmail.com',1,11,1),
(2,'Tom','Pitt','Manager','565-789-7896','tom.pit@gmail.com',3,12,1),
(3,'David','Lawrence','Cashier','852-789-7896','david.lawr@gmail.com',2,13,1),
(4,'Joseph','Aniston','Cook','765-789-7896','joseph.anis@gmail.com',2,14,1),
(5,'Jeny','Patel','Manager','531-789-7896','jeny.patel@gmail.com',3,15,1);
INSERT INTO `hotel_chain_has_hotel`(`hotel_chains_hotel_chain_id`, `hotels_hotel_id`)
VALUES
(1,1),
(1,2),
(1,3),
32. INSERT INTO `hotel_services_used_by_guests` (`service_used_id`,
`hotel_services_service_id`, `bookings_booking_id`)
VALUES ('1', '1', '2'),
('2', '2', '2'),
('3', '3', '2');
TRIGGER
USE hotel_database;
SET sql_notes = 0; -- Temporarily disable the "Table already exists" warning
-- create table for bookings audit
CREATE TABLE IF NOT EXISTS hotel_database.Bookings_Audit(
audit_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
`booking_id` INT NOT NULL,
`booking_date` DATETIME NULL,
`duration_of_stay` VARCHAR(10) NULL,
`check_in_date` DATETIME NULL,
`check_out_date` DATETIME NULL,
`booking_payment_type` VARCHAR(45) NULL,
`total_rooms_booked` INT NULL,
`hotel_hotel_id` INT NOT NULL,
`guests_guest_id` INT NOT NULL,
`employees_emp_id` INT NOT NULL,
`total_amount` DECIMAL(10,2) NULL,
action_type varchar(50) NOT NULL,
date_updated datetime NOT NULL
);
33. DROP TRIGGER IF EXISTS bookings_after_delete;
DELIMITER //
CREATE TRIGGER bookings_after_delete
AFTER DELETE ON bookings
FOR EACH ROW
BEGIN
INSERT INTO Bookings_Audit VALUES
(NULL, OLD.booking_id, OLD.booking_date, OLD.duration_of_stay, OLD.`check_in_date`,
OLD.`check_out_date`, OLD.`booking_payment_type`, OLD.`total_rooms_booked`,
OLD.`hotel_hotel_id`, OLD.`guests_guest_id`, OLD.`employees_emp_id`,
OLD.`total_amount`,"DELETED", NOW());
END//
DELIMITER ;
SET sql_notes = 1; -- And then re-enable the warning again
34. Conclusion
Prior to this project, a general study of hotel management system was conducted from
recent research of various authors and facts were gathered in which helped to uncover the
misfits that the system was facing. After proper analysation of these problems, a solution
was then developed to meet up the needs of a more advanced system.
Future work
In light with the current development in computing where everything is moving to cloud
technology, our hotel management system is developed with the future in mind, and it is
therefore scalable and can easily be transformed into a cloud server that various hotels can
tap into and get required data and utilize various functionalities. On a short-term basis
however, we are looking into SMS integration, where alerts and notifications will be sent to
user’s mobile phones.