RAVI RANA HOTEL MANAGEMENT PPT

ONLINE HOTEL BOOKING SYSTEM
PRESENTED BY:
RAVIKUMAR
(11csixx639)

TABLE OF CONTENT
Introduction
Module Description
Feasibility Study
Hardware & Software Requirements
DotNet Framework Architecture
Database Tables
ER Diagram
Database Table
Snapshots
Future & Scope

INTRODUCTION
The website which deals with the easy online reservation
in a hotel with high security and is known as, “ONLINE
HOTEL BOOKING SYSTEM”. This Project Provides
solution regarding the hotel reservation problems of
users. User can easily check availability of room & if
room is available, then he/she can get room in the hotel.
By the use of Internet the user can save so much time for
his reservation.

MODULE DESCRIPTION
Administrator module and User module:
Administrator Module:
Can Login
Check Customer details
Room details
Update Room Status
User Module :
Check room Availability
Fill Reservation Form
Get Reservation Slip

FEASIBILITY STUDY
Economic Feasibility :
 Cost-saving
 Improve-service Level
 Improve-information Level
 Time-saving
Behavioral Feasibility :
 Easier working with manual systems
 Information gathering easier
 Admin controls & manages user’s data

HARDWARE & SOFTWARE REQUIREMENTS
Hardware Configuration :
Processor : Pentium III or higher
RAM : 128 MB or More
Hard Disk : 20 GB or More
Software Configuration :
Operating System: : Windows XP, VISTA, 7.
Web Server : SQL Server 2008
Front End : ASP .NET
Scripts : JavaScript
Language : C# & HTML,CSS

DOTNET FRAMEWORK COMPONENTS
 There are two components :
• Common Language Runtime(CLR)
• Framework Class Library(FCL)

DATABASE TABLES
LOGIN:
Column Name Datatype
id int
emailid Nvarchar(50)
password Nvarchar(50)
userid int

Cont……
Enquiry:
id int
First_name Varchar(50)
Last_name Varchar(50)
Contact_no nvarchar(50)
Email_id nvarchar(50)
state Varchar(50)
city Varchar(50)
message nvarchar(50)

Cont….
Feedback:
Destination:
id int
name Varchar(50)
email_id Nvarchar(50)
message Varchar(50)
Columns Name Datatype
id int
name Varchar(50)

Cont…
ONLINE BOOKING:
id int
destination Varchar(50)
Start_date nvarchar(50)
End_date nvarchar(50)
No_of_days int
Room_type Varchar(50)
adults nvarchar(50)
childs nvarchar(50)
Contact_no nvarchar(50)
Email_id ncarchar(50)

Cont….
REGISTRATION:
id int
Date_of_birth Nvarchar(50)
Wedding_aniversary Nvarchar(50)
Contact nvarchar(50)
Emailid nvarchar(50)
password nvarchar(50)
userid int

Cont…
ROOMTYPE:
PAYMENT:
id int
Room_type Varchar(50)
id int
Payment_way Varchar(50)

ER DIAGRAM
An entity-relationship (ER) diagram is a specialized
graphic that illustrates the interrelationships between
entities in a database. ER diagrams often use symbols to
represent three different types of information. Boxes are
commonly used to represent entities. Diamonds are
normally used to represent relationships and ovals are
used to represent attributes.
Symbols used in this E-R Diagram:
• Entity:

Cont….
• Attributes:
• Relationship:

ER DIAGRAM OF ONLINE HOTEL BOOKING SYSTEM:
Guests
id
Phone
Address
password fname
Lname
emailid
Rooms
id
level
Room_t
ype userid
Reservation checkin
checkout
id
request
reserve

DATAFLOW DIAGRAM
A Data Flow Diagram (DFD) is a graphical
representation of the "flow" of data through an
Information System. A data flow diagram can also be
used for the visualization of Data Processing. It is
common practice for a designer to draw a context-level
DFD first which shows the interaction between the
system and outside entities. This context-level DFD is
then "exploded" to show more detail of the system being
modeled.

Cont…
DATA FLOW DIAGRAM NOTATIONS
• FUNCTION:
• FILE/DATABASE:
• INPUT/OUTPUT:
• FLOW OF DORECTION:

DATA FLOW DIAGRAMS:
Level 0:
user hotel database

Cont….
Level 1:
Admin
user
Hotel
Customer
Detail
Room
Status
Update
Room
Reservation
Database

SCOPE & FUTURE ENHANCEMENT
The scope of the system is the area which it covers with
respect to its functionality. The scope of the system includes
its function and range.
The scopes of the system will be:-
It fulfills all an office application automatically with
minimal overhead.
Functionality of sharing of new view and ideas between
employees will be added in next version.
It will provide the information of running project , late
project and completed project .It will add the functionality
of seeing his/her performance graph in company to
increase his performance and it will also help to provide
clear picture of employee’s salary.

RAVI RANA HOTEL MANAGEMENT PPT

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to RAVI RANA HOTEL MANAGEMENT PPT

Similar to RAVI RANA HOTEL MANAGEMENT PPT (20)

Recently uploaded

Recently uploaded (20)

RAVI RANA HOTEL MANAGEMENT PPT