Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Transcript of HOTEL MANAGEMENT
User as Costumer
firstly, costumer reserves a room...
recepsionist access database
insert new query to the CHECK IN table
costumer Get the Bill
after pay the bill, before checkin Out from the hotel, Costumer will be noticed the Bill containing data such as:
Date, no Invoice, room service..etc
The Bill will be stored in Bill Table
so the costumer Get the printed Bill
insert into CHECK IN values (checkInId,
access costumer ID and emp_Id
as foreign key frm other table
new query for CHECK OUT table is inserted
insert into CHECK OUT values(checkoutID,
cout_date, costumerID, emp_ID)
Notice the Guest Their Room and its Key
They are allowed to read Room database and making update whenever the room is ready to reserve or not.
Checking Guest In and Out of the Hotel
They are allowed to access Check In and Check Out Database and make changes in it.
Note any order of Guests
They are allowed to manage Costumer data order and make changes on it. Adding any value such as breakfast, laundry etc.
Calculate Guests Bill
Allowed to manage BILL table and make changes on it.
They are also responsible to give the bill to the Guests.
They are allowed to make new query to reservation table
and even making update on it.
READ ALL DATABASE IN THE HOTEL
(NOT TO WRITE)
access data of employee to recruit and monitor the staff of hotel
Read the Bill database to check the financial Income of the Hotel
Review reservation and costumer database
As he is the responsible of budget preparation and marketing strategy
to increase efficiency and services
HOTEL MANAGEMENT DATABASE
PRESENTED BY :
I NYOMAN WICAHYA
IRFAN KARUNIA ROZAN ROIF
THANK YOU FOR YOUR KIND ATTENTION
create table customer(customer_ID varchar(25) primary key not null foreign key,customer_name varchar(50),customer_email varchar(50),customer_phone varchar(25));
create table room(room_number varchar(10) primary key not null,room_type varchar(25),room_occupied varchar(10),room_price float));
create table reservation(reservation_ID varchar(25)primary key not null,reservetion_date varchar(25),reservation_type varchar(25),employee_ID varchar(25));
create table employee(employee_ID varchar(25) primary key not null,employee_name varchar(50),employee_position varchar(25));
create table bill(bill_ID varchar(25) primary key not null,payment_type varchar(25),payment_date varchar(25),price float,customer_ID varchar(25),employee_name varchar(50));
create table manager(manager_ID varchar(25) primary key not null,manager_name varchar(50));
create table checks_in(cin_no varchar(25) primary key not null,cin_date varchar(25),customer_ID varchar(25));
create table checks_out(cout_no varchar(25) primary key not null,cout_date varchar(25),customer_ID varchar(25));
alter table reservation add foreign key(employee_ID) references employee(employee_ID);
alter table bill add foreign key(customer_ID) references customer(customer_ID);
alter table checks_in add foreign key(customer_ID) references customer(customer_ID);
alter table checks_out add foreign key(customer_ID) references customer(customer_ID);
EVERY BILL DATA IS RECORDED TO FINANCIAL TABLE
TO BE REVIEWED,THEN, BY MANAGER