Hotel Booking Project

Our hotel booking project with databases

Table of Contents

• Introduction
  • Goal
  • Context
• Description
• Characteristics of business processes
  • Purpose of the system
  • Interaction with users
  • Characteristics of business relations
  • Target audience
• Functionality
• API
  • Admin.cs
    • ChangePermissions(id, permission)
  • Authorized.cs
    • Book(bookfields)
    • CheckBookings(id)
    • Review(reviewfields)
    • CancelBooking(id)
    • AddHotel(hotelFields)
  • DBSystem.cs
    • GetReviews(id)
    • GetRoom(id)
    • GetUser(id)
    • GetHotel(id)
  • HotelAdmin.cs
    • UpdateHotelInfo(hotelFields)
    • UpdateRoom(fields)
  • HotelOwner.cs
    • ChangeAccess(fields)
    • RemoveHotel(id)
  • Unauthorized.cs
    • SignUpLogIn(login_str, password_str)
  • User.cs
    • SearchForInfo(fields)
• Interested parties
• Availability
• Reliability
• Team
• Database schema
• Creation date
• Change Log
• Badges
• License

Introduction

Nowadays, number of tourists are growing fast. And hotel reservations are always relevant and necessary for people. Therefore, we want to develop a convenient database with useful information and rich functionality.

Description

Booking is an online travel agency for lodging reservations or, in other words, is a convenient way for any traveler to order a room in any part of the world without any problems. Users will be able to view each hotel and room in it to choose the most suitable option to make their trip abroad or around the country impeccable.

Goal

• make information about hotels more public and smart
• make booking a room easier

Context

The user can easily book a room without seeing unnecessary information, only useful. Everything related to the booking will be notified to the user via email

Characteristics of business processes

Purpose of the system

Hotel Booking DB was created to facilitate the operation of online hotel reservation systems. The database will help your program or site to store all the necessary information correctly, securely and in a structured way. This system will have the function of notifying users via email as well as many other useful functions.

Interaction with users

Interaction with the database occurs through certain functions that return the desired values or perform certain operations. By connecting Hotel Booking DB to your project, your users will be able to quickly view the hotels or reservations they need, leave a review of their favorite place to stay or add their own small motel. The registration system will include a login, password and e-mail.

Characteristics of business relations

System management will be performed using a separate application section (for administrators only) and using a special administration team consisting of administrators and system operators. Users who have added their property to the database will be able to change the parameters of their proposals after the previous moderation.

Target audience

The target audience of Hotel Booking DB is the developers of any hotel room reservation system.

Functionality

Unauthorized users can

• Search based on hotel, apartment, inn etc for info (Address, Ratings, and Price)
• Check available rooms
• Check for latest promotion and deals
• Sign up, log in

Authorized users can

• Book online, pay with credit or debit card
• See check in and check out dates
• Leave comments and reviews, rate services
• Cancel booking
• Log out
• Edit customer's booking information (updating check in, check out, room preferences, bad preferences and also cancelling booking) (for hotel admins only)
• Update hotel info and prices (for hotel admins only)

Implementation of functions below is left for clients:

• Receive emails about discounts and order updates
• Report comments

Admins can

• Change permissions for users or hotels

Implementation of functions below is left for clients:

• Content moderation
• Users support

Table Of Precedents

E-R Diagram

API

Admin.cs

ChangePermissions(id, permission)

Name	Type	Argument	Default	Description
id	int	required	None	user's identifier
permission	int	required	None	user's permission

Authorized.cs

Book(bookfields)

Name	Type	Argument	Default	Description
bookfields	object[]	required	None	information for booking

CheckBookings(id)

Name	Type	Argument	Default	Description
id	int	required	None	user's identifier

Review(reviewfields)

Name	Type	Argument	Default	Description
reviewfields	object[]	required	None	information for creating review

CancelBooking(id)

Name	Type	Argument	Default	Description
id	int	required	None	books's identifier

AddHotel(hotelFields)

Name	Type	Argument	Default	Description
hotelFields	object[]	required	None	information about hotel

DBSystem.cs

GetReviews(id)

Name	Type	Argument	Default	Description
id	int	required	None	review's identifier

GetRoom(id)

Name	Type	Argument	Default	Description
id	int	required	None	room's identifier

GetUser(id)

Name	Type	Argument	Default	Description
id	int	required	None	user's identifier

GetHotel(id)

Name	Type	Argument	Default	Description
id	int	required	None	hotel's identifier

HotelAdmin.cs

UpdateHotelInfo(hotelFields)

Name	Type	Argument	Default	Description
hotelFields	object[]	required	None	information about hotel

UpdateRoom(fields)

Name	Type	Argument	Default	Description
fields	object[]	required	None	information about room

HotelOwner.cs

ChangeAccess(fields)

Name	Type	Argument	Default	Description
fields	object[]	required	None	information for updating room

RemoveHotel(id)

Name	Type	Argument	Default	Description
id	int	required	None	information for removing hotel

Unauthorized.cs

SignUpLogIn(login_str, password_str)

Name	Type	Argument	Default	Description
login_str	string	required	None	user's login
password_str	string	required	None	user's password

User.cs

SearchForInfo(fields)

Name	Type	Argument	Default	Description
fields	object[]	required	None	information for searching info

Interested parties

Below is given a list of parties, that may be interested in our project:

• People, who are searching for a bed, a room or a flat to stay for some period of time;
• Hotels, which are looking for customers.

Availability

Hotel Booking DB is available for everyone, who will install our module and connect it to their own project.
It has no UI yet, but connection to the server is available with the use of English and letters from us coming to your email can be different, depending on the language you choose (English, Russian, Ukrainian).
We provide "help" command, which helps user to understand functionality of DB.

Reliability

The reliability of this project will be extremely high, because the main language for implementing the database in it is C#, which is an OOP language. It allows you to make the data of all users strictly classified. Also, the data will be saved on the servers, which will allow you to restore them if necessary.

Team

• Zavalniuk Maksym
• Dominskyi Valentyn
• Dmytrenko Roman
• Gorbunova Yelyzaveta
• Palchyk Maksym
• Sichkar Tetiana

Database schema

Class diagram

Creation date

7.09.2020

Change Log

Change Log

Badges

License

MIT © mezidia