Data base and design

Description:

This project basically designs the database for hotel management system. There are different entities, attributes related to each entity and relationships between tables. There are many queries where we can find or retrieve the required information from a single or multiple table. This database is not that much advanced but can be one of the effective one in hotel management system.

Purposes:

The main Opportunity of this project is for online platform. Customers may have problem on making reservation for hotel rooms so customers can reserve or book the room as they want. Whenever the customer book the room, it will get update in reservation table. More, the Admin can run the queries and can see the status of their business. They will know the number of people book the room or anything they want by running specific query. Hence, this database will not only help in running queries but also helps in growing business.

Operational scenarios:

Operational Scenarios for our Hotel Management System is simple. There are six tables, and each table provides specific information of different sectors of the hotel management. When the customer shows up, the information of the customer is entering into the database like their name, their phone number, email, and other information’s. Once the information of the customer is entered then we ask for their choice of the room. we can assign them the room number. One for feature has been included that the customer can reserve the room in some other date and can check in another date.

List of tables:

· Costumer

· Today Price

· Room

· Hotel

· Employee

· Bill

Project Members & Responsibilities:

Name	Roles & Responsibilities
Sahadev Shrestha	Documentation Writer
Sangam Shrestha	System Analyst
Pranay Singh	Database Administrator

2. E-R Diagram:

Phase 2:

Changing ER-diagram into Relational Model

mysql command codes used;

Show databases; //show total database present

Use username_HotelMangementSystem; //using the database we need

Create table [Table Name]; // command for creating the tables that need there are Customer, Bill, TodayPrice, Room, Hotel and Employee tables.

Insert into [Table Name]; // command for inserting the values in the tables.

Select * from [Table Name]; //command for output of the values. This command provide the visual output of the inserted data.

Table:

Customer Table and Details:

Room Numbers:

Bill table:

Price table:

Hotel details:

Employee table and their details: