Ques 1.

A XYZ-star hotel requires a computerized system to automize its front office operations
that support the following functionalities:
 Easy input facility for new data
 Keep details about rooms, tariff, details of occupied rooms, details of unoccupied rooms, check-in
/ check-out timings, staff etc..
 Update necessary details about the room-billing, extra facilities used like gym, laundry,
STD/ISD calls made etc.
 Query support
 Report generation
Perform the following tasks:
(i) Draw the ER diagram by identifying the entities, relationships and cardinality by using
any of the drawing tools like smartdraw, dia, visio, conceptdraw etc.. Follow proper
conventions.
(ii) Create suitable database to support/accommodate all the functionalities referred above.
(iii) Using MS-Access, design various forms to support the hotels’ front office operations such as enquiry form, tariff, categories of rooms along with their category, list of vacant rooms, list of occupied rooms, list of unoccupied rooms, room-billing (which includes extra facilities also), restaurant billing, staff details, list of phone numbers, reservations etc..
(iv) Report generation like daily reports of list of vacant rooms, list of occupied rooms, onduty staff list, list of room reservations made etc.