n047_dd (hotel management system)
TRANSCRIPT
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Hotel Management System
Design Document
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 2 of 22
REVISION HISTORY
Date Version Description Author
03/11/2006 1.0 Initial Version
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 3 of 22
TABLE OF CONTENTS
1 INTRODUCTION____________________________________________ 4
2 HIGH LEVEL DESIGN OVERVIEW_________________________________ 4 2.1 System Objectives............................................................................................ 4 2.2 Design Considerations ...................................................................................... 4 2.3 System Architecture ......................................................................................... 5 2.4 Procedural Design............................................................................................ 6 2.5 Database Schema ............................................................................................ 8 2.6 Database Design Diagram............................................................................... 11 2.7 Module Decomposition ................................................................................... 11 2.8 Inter-Module Relationships ............................................................................. 22
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 4 of 22
1 INTRODUCTION Hotel Management System application consists of the following modules:
•
•
•
•
•
•
•
•
Administrator Module
Hotel Owner Module
User Module
Administrator Module
Administrator Module allows the Administrator to add the details of the new hotel,
modify the details of the existing hotel, and view the details of the hotel.
Hotel Owner Module
Hotel Owner Module allows the Hotel Owner to add, modify, and view room details,
add new items to the menu, view item list, modify and delete the list items, view and
accept the customers’ orders, and view the reports.
User Module
User Module allows the User to view hotel details, place an order, and check the
status of the order.
2 HIGH LEVEL DESIGN OVERVIEW
2.1 System Objectives
The objective of the Hotel Management System application is to automate and
accomplish the task of two modules namely:
Administrator Module
Hotel Owner Module
User Module
2.2 Design Considerations Hotel Management System application should be developed in ASP.NET using
C#.NET.
Administrator, Hotel Owner, and User interact with the system through .aspx
pages.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 5 of 22
• The end-user of the system should accomplish their tasks with minimal
navigations.
2.3 System Architecture
Database
Hotel Management System ApplicationUser
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 6 of 22
2.4 Procedural Design
2.4.1 Process of Administration Module
Start
Enter Username& Password
2
Select 1. Hotel Details
2. Add Hotel
Enter Hotel Details& Login Details
IfValid?
No
Add Hotel Detailsto Database
Display Message"Details are Added"
IfValid?
No
Yes
1
Update
Display all Hotel Details
IfValid?
No
Enter Detailsto Update
Yes
Hotel Detailsare Modified
Display HotelDetails are Modified
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 7 of 22
2.4.2 Process of User Module
1 2
Display InvalidProcess No
Select1. View Hotels
2. Order Status
If Service Typeis Food Items
Display theHotel items Yes
Yes
No
Select Area, Hotel, & Service Type
Select theItems
Enter Quantity
Enter Date
Select theItems
Enter No. ofRooms
Book
Display theOrdered Details
Enter theClient Details
Submit
Display Order is sent to Administrator
and Process No.
Order
Display theOrdered Items
Enter theClient Details
Submit
Display Order is sent to Administrator
and Process No.
Enter Process No.
Show
No If Process Nois Vaid?
C
Select theItems
IfStatus = Sent
Cancel Order
Display OrderCanceled
Display theItems Information
No If
Status = Sent
No
Yes
Yes
Display theItems Information
Display Message" Rooms
are not Alloted "
Display Message" Rooms are Alloted "
Start
No
If Service Type is Food Items
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 8 of 22
2.4.3 Process of Owner Module
Display Itemsare Added
Select1. Submit
2. Reset
Select theItems
Display SelectedItems are Deleted
Enter Old & New Password Details
Submit
DisplayChange Password
Start
1
2
Enter Username& Password
Select Room Type,Enter No. of
Rooms & Amount
Add Room Details to Database
1
Display RoomDetails
Enter ItemDetails
Delete
Enter No. ofRooms & Amount
Update
Update Room Details to Database
2
Select Service Type
Display allClient Orders
Click Name
Accept
Display Itemsare Sent
Display allClient Orders
Click Name
Display ClientOrdered Items
Accept
Display Itemsare Sent
Display ClientOrdered Items
Room
Food
If Service Type is ?
Display the totalamount & Hotel
Items Information
Select 1. Add Rooms 2. View Rooms
3. Add Menun Items 4. View Menun Items 5. Orders 6. Charge password 7. Report
3 4
Display theHotel Items
5 6 7
2.5 Database Schema Table Name: tbl_Client S.No Field Name Type Size Relation Table Constraints
1 fld_UserID int 4 Primary Key 2 fld_OrderID int 4 tbl_OrderMaster Foreign Key 3 fld_UserName varchar 20 4 fld_ContactNo varchar 15 5 fld_Address varchar 50 6 fld_ProcessNo char 10 7 fld_Date smalldatetime 4 8 fld_Time char 10 9 fld_Status char 10
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 9 of 22
Table Name: tbl_OrderItems S.No Field Name Type Size Relation Table Constraints
1 fld_Sno int 4 Primary Key 2 fld_OrderID int 4 tbl_OrderMaster Foreign Key 3 fld_ItemID int 4 tbl_RestaurantItems Foreign Key 4 fld_Qty int 4 5 fld_Status bit 1
Table Name: tbl_OrderMaster S.No Field Name Type Size Relation Table Constraints
1 fld_OrderID int 4 Primary Key 2 fld_RestaurantID int 4 tbl_Restaurants Foreign Key 3 fld_OrderDate smallda
tetime 4
4 fld_ServiceType char 10 Table Name: tbl_OrderRooms S.No Field Name Type Size Relation Table Constraints
1 fld_Sno int 4 Primary Key 2 fld_OrderID int 4 tbl_OrderMaster Foreign Key 3 fld_RoomID int 4 tbl_Rooms Foreign Key 4 fld_Status bit 1
Table Name: tbl_RestaurantItems S.No Field Name Type Size Relation Table Constraints
1 fld_ItemID int 4 Primary Key 2 fld_RestaurantID int 4 tbl_Restaurants Foreign Key 3 fld_ItemName varchar 20 4 fld_ItemType char 10 5 fld_Price money 8 6 fld_ItemStatus bit 1
Table Name: tbl_Rooms S.No Field Name Type Size Relation Table Constraints
1 fld_RoomID int 4 Primary Key 2 fld_RestaurantID int 4 tbl_Restaurants Foreign Key 3 fld_RoomType char 10 4 fld_NoofRooms Int 10 5 fld_Amount money 8 6 fld_AvilableRooms Int 4
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 10 of 22
Table Name: tbl_Restaurants S.No Field Name Type Size Relation Table Constraints
1 fld_RestaurantID int 4 Primary Key 2 fld_RestaurantName varchar 20 3 fld_RestaurantType varchar 20 4 fld_Amount int 4 5 fld_OwnerName varchar 20 6 fld_Area varchar 20 7 fld_ContactNo varchar 15 8 fld_Address varchar 50 9 fld_UserName varchar 15
10 fld_Password varchar 15 Table Name: tbl_RoomDetails S.No Field Name Type Size Relation Table Constraints
1 fld_RoomID int 4 tbl_Rooms Foreign Key 2 fld_RoomNo int 4 3 fld_OrderID int 4
Table Name: tbl_Restaurants S.No Field Name Type Size Relation Table Constraints
1 fld_RestaurantID int 4 Primary Key 2 fld_RestaurantName varchar 20 3 fld_RestaurantType char 10 4 fld_Amount int 4 5 fld_OwnerName varchar 20 6 fld_Area varchar 20 7 fld_ContactNo varchar 15 8 fld_Address varchar 15 9 fld_UserName varchar 15
10 fld_Password varchar 15
11 fld_ValidFrom smalldatetime 4
12 fld_ValidTo smalldatetime 4
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 11 of 22
2.6 Database Design Diagram
2.7 Module Decomposition
The Work Break-down Structure of the Hotel Management System application results
in the following modules:
2.7.1 Administrator Module
Login •
•
Entry
The inputs to this module are:
Username
Password
Task
Administrator Module should authenticate the Administrator by validating
Username and Password combination. By default, Username and Password are
set as ‘Wipro’ and ‘Wipro’ respectively.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 12 of 22
•
•
Validations
Username and Password should have minimum 3 and maximum 15
alphanumeric characters, else the Administrator Module should display
proper message.
If any of the fields left blank, the Administrator Module should display
appropriate message.
Hotel Details Task
Administrator Module should allow the Administrator to view the list of hotels with
following details:
Hotel Username
Hotel Name
Hotel Type
Amount
Name
Contact Number
Address
Administrator Module should allow the Administrator to edit the following details
of a hotel by clicking on <Edit> button:
Hotel Name
Hotel Type
Amount
Contact Number
Address
Administrator Module should facilitate the Administrator to save the changes
made by clicking on <Update> button and cancel the selected record by clicking
on <Cancel> button.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 13 of 22
Add Hotel •
•
•
Entry
The inputs to this module are:
Hotel Name
Hotel Type
Amount
Hotel Owner Name
Area
Contact Number
Address
Hotel Username
Password
Confirm Password
Task
Administrator Module should allow the Administrator to add hotel by furnishing
the above details.
Validations
Hotel Name and Hotel Owner Name should have minimum 3 and maximum
20 alphabet characters, else the Administrator Module should display proper
message.
Amount should have minimum Rs. 100 and maximum Rs. 1000, else the
Administrator Module should display proper message.
Area should have minimum 3 and maximum 20 alphabet characters, else the
application should display proper message.
Contact Number should have minimum 6 and maximum 15 digits, else the
Administrator Module should display proper message.
Address should have minimum 10 and maximum 50 characters, else the
Administrator Module should display proper message.
Hotel Username should have minimum 3 and maximum 15 alphanumeric
characters, else the Administrator Module should display proper message.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 14 of 22
Password should have minimum 3 and maximum 15 characters, else the
Administrator Module should display proper message
Password and Confirm Password should be the same, else the Administrator
Module should display proper message
If any of the fields left blank, Administrator Module should display appropriate
message.
Logout Administrator Module should allow the Administrator to quit the application by
clicking on logout.
2.7.2 Hotel Owner Module
Login •
•
•
•
Entry
The inputs to this module are:
Username
Password
Task
Hotel Owner Module should authenticate the Hotel Owner to the system by
validating the Username and Password Combination.
Validations
Username and Password should have minimum 3 and maximum 15
alphanumeric characters, else the Hotel Owner Module should display proper
message.
If any of the fields left blank, the Hotel Owner Module should display
appropriate message.
Add Rooms Entry
The inputs to this module are:
No. of Rooms
Amount
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 15 of 22
•
•
•
•
Task
Hotel Owner Module should allow the Hotel Owner to select the ‘Room Type’
from the dropdown list, enter the above details of room and click on <Submit>
button to add rooms.
Hotel Owner Module should also facilitate the Hotel Owner to clear the above
fields by clicking on <Reset> button.
Validations
No. of Rooms should have minimum 1 and maximum 9999 digits, else the
Hotel Owner Module should display proper message.
Amount should have minimum Rs. 100 and maximum Rs. 1000, else the
Hotel Owner Module should display proper message.
If any of the fields left blank, the Hotel Owner Module should display
appropriate message.
View Rooms Task
Hotel Owner Module should allow the Hotel Owner to view the list of rooms with
following details:
Room Type
No. of Rooms
Amount
Hotel Owner Module should allow the Hotel Owner to edit the ‘No of Rooms’ and
‘Amount’ of the selected room by clicking on <Edit> button, allow the hotel owner
to save the changes made by clicking on <Update> button, and cancel the
selected room by clicking on <Cancel> button.
Hotel Owner Module should also facilitate the Hotel Owner to delete the selected
room by clicking on <Delete> button.
Add Menu Items Entry
The inputs to this module are:
Item Name
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 16 of 22
Price
Item Type
•
•
•
Task
Hotel Owner Module should allow the Hotel Owner to enter the above details of
items and click on <Submit> button to add a new item:
Hotel Owner Module should also facilitate the Hotel Owner to clear the above
fields by clicking on <Reset> button.
Validations
Item Name should have minimum 3 and maximum 20 alphabet characters,
else the Hotel Owner Module should display proper message.
Price should have minimum Rs. 1 and maximum Rs. 1000, else the Hotel
Owner Module should display proper message.
If any of the fields left blank, Hotel Owner Module should display appropriate
message
View Menu Details Task
Hotel Owner module should allow the Hotel Owner to view the list of menu items
with following details:
Item Name
Price
Item Type
Hotel Owner Module should allow the Hotel Owner to edit the ‘Price’ of an Item by
clicking on <Edit> button, allow the hotel owner to save the changes made by
clicking on <Update> button, and cancel the selected item by clicking on
<Cancel> button.
Hotel Owner Module should facilitate the Hotel Owner to delete the selected item
by clicking on <Delete> button
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 17 of 22
Orders • Task
Hotel Owner Module should allow the Hotel Owner to select the ‘Food Items’
option from the Service Type dropdown list and click on <show> button to view
the food item details.
Hotel Owner Module should allow the Hotel Owner to view the following details of
the requested food items:
Name
Contact Number
Address
Date
Hotel Owner Module should allow the Hotel Owner to view the following details of
the items ordered by clicking on ‘Name’ hyperlink:
Total Amount
Name
Contact Number
Address
Time
Item Name
Price
Item Type
Quantity
Hotel Owner Module should allow the Hotel Owner to accept the customers’
requests by clicking on <Accept> button.
Hotel Owner Module should allow the Hotel Owner to select the ‘Room Booking’
option from the Service Type dropdown list and click on <show> button, to view
the room booking details.
Hotel Owner Module should allow the Hotel Owner to view the following details of
the booked rooms:
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 18 of 22
Name
Contact Number
Address
Date
Hotel Owner Module should allow the Hotel Owner to view the following details of
the items ordered by clicking on ‘Name’ hyperlink:
Total Amount
Name
Contact Number
Address
Date
Room Type
Amount
No. of Rooms
Hotel Owner Module should allow the Hotel Owner to accept the customers’
requests by clicking on <Accept> button.
Change Password •
•
•
Entry
The inputs to this module are:
Old Password
New Password
Retype Password
Task
Hotel Owner Module should allow the Hotel Owner to change the password by
furnishing the above details.
Validations
Old, New, and Retype Password should have minimum of 3 and maximum of
15 characters. If not the Hotel Owner Module should display proper message.
Password and Retype Password should be the same, if not the Hotel Owner
Module should display proper message.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 19 of 22
Reports •
•
•
Task
Hotel Owner Module should allow the Hotel Owner to view the daily report with
the following details:
Total Amount
Item Name
Price
Item Type
Quantity
Logout Hotel Owner Module should allow the Hotel Owner to quit the application by
clicking on logout.
2.7.3 User Module
View Hotel Entry
The input to this module is:
Date
Task
User Module should allow the User to select the ‘Area’, ‘Hotel Name’, and
‘Service Type’ from the dropdown list and click on <Show> button to view the list
of menu items with the following details:
Item Name
Price
Item Type
Quantity
User Module should allow the User to select the item, click on <Order> button,
furnish the following details, and click on <Submit> button to place an order:
Name
Contact Number
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 20 of 22
Time
Address
User Module should automatically generate the Processing Number after
customers’ orders are processed successfully.
User Module should allow the User to select the ‘Area’, ‘Hotel Name’, and
‘Service Type’ from the dropdown list, enter Date, and click on <Show> button to
view the list of rooms with the following details:
Room Type
No. of Rooms
Available Rooms
No. of Rooms
User Module should allow the User to select the room, click on <Book> button,
furnish the following details, and click on <Submit> button to book the room(s):
Name
Contact Number
Address
User Module should automatically generate the Processing Number after
customers’ orders are processed successfully.
•
•
•
Validations
Date should have (mm/dd/yyyy) format, else the User Module should display
proper message.
Order Status Entry
The input to this module is:
Process Number
Task
User Module should allow the User to enter the ‘Process Number’ and click on
<Show> button to view the status of the order.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 21 of 22
Order Status for the food items should be displayed with the following
information:
Status
Total Amount
Name
Contact Number
Address
Time
Item Name
Price
Item Type
Quantity
User Module should facilitate the User to cancel the order by selecting the item
and clicking on <Cancel Order> button.
Order Status for the booked Rooms should be displayed with the following
information:
Status
Total Amount
Name
Contact Number
Address
Date
Room Type
Amount
No. of Rooms
• Validations
Process Number should be valid, else the User Module should display proper
message.
DESIGN DOCUMENT
HO T E L MA N A G E M E N T SY S T E M VERSION: 1.0
Talent Transformation Page 22 of 22
Logout User Module should allow the User to quit the application by clicking on Logout.
2.8 Inter-Module Relationships
All the modules of Hotel Management System application are fairly integrated in the
sense that each module exhibits a high degree of cohesion and fan-in.