DATABASE MANAGEMENT SYSTEM PROJECT

HOTEL MANAGEMENT SYSTEM

NAME IDNO

1, Eyerusalem Kebadu 0712/19

2, Meseret Gonche 1173/19
3, Hana Wedaje 0962/19
4, Kirubel Ayele 1300/19
5, Bereket Birhanu 0706/19
6, Zelalem Yiheyis 0748/19
7, Istifanos Birhanu 0864/19

Submitted date- April 13 2021

 Table of contents

1, INTRODUCTION 1
2, REQUIRMENT 2
3, ER DIAGRAM 3
4, DATABASE SCHEMA 4
5, NORMALIZTION 5

INTRODUCTION
 Hotel is a place where people can stay and provides food,
lodging, and other services for paying guests.

 Hotel management system is a type of properly

management system that facilitates the management of hotel
operations and functions.

 The term hotel management system includes the

management of each and every aspects related to the hotel
for the attraction, smoothness of handling things , and
proper management .Especially the reservation services,
payment moods and extra activities should be handled.

 One of the most important sector for the economic growth of

the country is the tourism sector so we have good behavior
and a good management plays a major role for their
attraction.

REQUIARMENT
 Entity relational schema
1. Employeetbl
 2. Managertbl
3. Billtbl
4. Invoicetbl
5. Roomtbl
6. Custemortbl

 Relationships
 Customer relate with invoice by payment
 Customer relate with Room with check in out
 Room relate with room category by of
 Invoice relate with Bill by has

 NORMALIZATION
1. 1NF
2. 2NF
3. 3NF

 SQL SERVER DATABASE CONSTRIANTS

 NULL / NOT NULL
 Primary key
 Default
 Check
 Unique
 Foreign key
 Identity key

2
er diagram

LName
IN_DESCRIPTION
FName
SSN IN_ID

STATUS
C_Name C_ID
 Country
INVOICE
CUSTOMER 1 1 1Has
Sex Payment LNAME m
e-mail
FNAME
m Date
Amount
P_method
C NAME
R_No

Bill_ID

ROOM n Checkin_out BILL

TYPE R_PRICE Type

Date

Date

Salary M_ID Salary

NAME ID address

1 1 EMPLOY Ssn
ADDRESS manages
MANAGER EE
Name

Mng_Start_Date

3
Database schema for hotel management system
Invoice table
In_statu In_ID
In_description
s

Customer table

C_nam C_ID C_sex C_country C- C_ssn

e Email
 Manager table
M_nam M_I M_salary M_addres Mng_start_date
e D

ROOM table
R_number R_ID R_price R_type

Room category

C_ID Name RoomNO

Employee

E_nam E_ID E_salary E_adres E_Ssn

e s
BILL table

Name Amount Bill_ID Type Date

Payment table

Payment method Date

RESERVATION

R_ID Period Date 4

NORMALIZATION
 Normalization is the process of decomposing unsatisfactory
‘’bad’’ relations by breaking up their attributes in to smaller
relations .

o 1NF: It disallows :- composite attribute

:- multivalued attribute
:- nested relations
 EXAMPLES:

CUSTOMERTBL
Redundancy

Fname Lname Ssn country Sex Id e-mail Pnumber

A B 12 ETHIOPIA F 1 [email protected] 1122
[email protected] 1133
C D 21 INDIA M 2 [email protected] 3443
[email protected] 1111
E F 05 AA M 3 [email protected] 0909
[email protected] 4543
m

Decompose in to two tables:

Fname Lname Ssn Country Sex Id
A B 12 ETHIOPIA F 1
C D 21 INDIA M 2
E F 05 AA M 3

ID e-mail Pnumber
1 [email protected] 1122
1 [email protected] 1133
2 [email protected] 3443
2 [email protected] 1111
3 [email protected] 4325
3 [email protected] 8765