A hotel has a certain number of rooms. Each room can be either single bed or double bed type and may be  AC or non-AC type. The rooms have different rates depending on whether they are of single or double,  AC or Non-AC types. The room tariff however may vary during different parts of the year depending up  on the occupancy rate. For this, the computer should be able to display the average occupancy rate for a  given month, so that the manager can revise the room tariff for the next month either upwards or  downwards by a certain percentage. Perform structured analysis and structured design for this Hotel  Automation Software—software that would automate the book keeping activities of a 5-star hotel. Guests can reserve rooms in advance or can reserve rooms on the spot depending upon availability of  rooms. The receptionist would enter data pertaining to guests such as their arrival time, advance paid,  approximate duration of stay, and the type of the room required. Depending on this data and subject to the  availability of a suitable room, the computer would allot a room number to the guest and assign a unique  token number to each guest. If the guest cannot be accommodated, the computer generates an apology  message. The hotel catering services manager would input the quantity and type of food items as and  when consumed by the guest, the token number of the guest, and the corresponding date and time. When  a customer prepares to check-out, the hotel automation software should generate the entire bill for the  customer and also print the balance amount payable by him. During check-out, guests can opt to register  themselves for a frequent guests programme. Frequent guests should be issued an identity number which  helps them to get special discounts on their bills.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

A hotel has a certain number of rooms. Each room can be either single bed or double bed type and may be 
AC or non-AC type. The rooms have different rates depending on whether they are of single or double, 
AC or Non-AC types. The room tariff however may vary during different parts of the year depending up 
on the occupancy rate. For this, the computer should be able to display the average occupancy rate for a 
given month, so that the manager can revise the room tariff for the next month either upwards or 
downwards by a certain percentage. Perform structured analysis and structured design for this Hotel 
Automation Software—software that would automate the book keeping activities of a 5-star hotel.
Guests can reserve rooms in advance or can reserve rooms on the spot depending upon availability of 
rooms. The receptionist would enter data pertaining to guests such as their arrival time, advance paid, 
approximate duration of stay, and the type of the room required. Depending on this data and subject to the 
availability of a suitable room, the computer would allot a room number to the guest and assign a unique 
token number to each guest. If the guest cannot be accommodated, the computer generates an apology 
message. The hotel catering services manager would input the quantity and type of food items as and 
when consumed by the guest, the token number of the guest, and the corresponding date and time. When 
a customer prepares to check-out, the hotel automation software should generate the entire bill for the 
customer and also print the balance amount payable by him. During check-out, guests can opt to register 
themselves for a frequent guests programme. Frequent guests should be issued an identity number which 
helps them to get special discounts on their bills.

Expert Solution
steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Random Class and its operations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education