Report Preparation Sample:

Hotel Management System

The main aim of the entire activity is to automate the process of day to day activities of Hotel like Room activities, Admission of a New Customer, Assign a room according to customer’s demand, check out of a computer and releasing the room and finally compute the bill etc.

The limited time and resources have restricted us to incorporate, in this project, only a main activities that are performed in a HOTEL Management System, but utmost care has been taken to make the system efficient and user-friendly.

“HOTEL Management System” has been designed to computerize the following functions that are performed by the system:

v  Room Detail Functions

v  Opening a New Room

v  Modification to room assigned

v  Check-in and check-out Detail Functions

v  Admission of New customer

v  Check-out of customer

v  Room assigning related to customer’s need.

v  Statement of Customer Details

v  Check-in customer

v  Check-out customer

v  Room Details

v  Total number of Customers in the Hotel

v  Individual customer Report

OBJECTIVE

During the past several decades’ personnel function has been transformed from a relatively obscure record keeping staff to central and top level management function. There are many factors that have influenced this transformation like technological advances, professionalism, and general recognition of human beings as most important resources.

A computer-based management system is designed to handle all the primary information required to calculate monthly statements. Separate database is maintained to handle all the details required for the correct statement calculation and generation.

This project intends to introduce more user friendliness in the various activities such as record updating, maintenance, and searching.

The searching of record has been made quite simple as all the details of the customer can be obtained by simply keying in the identification of that customer.

Similarly, record maintenance and updating can also be accomplished by using the identification of the customer with all the details being automatically generated. These details are also being promptly automatically updated in the master file thus keeping the record absolutely up-to-date.

The entire information has maintained in the database or Files and whoever wants to retrieve can’t retrieve, only authorization user can retrieve the necessary information which can be easily be accessible from the file.

The main objective of the entire activity is to automate the process of day to day.

Activities of Hotel like:

• Room activities,
• Admission of a New Customer,
• Assign a room according to customer’s demand,
• Check out of a computer and releasing the room
• Finally compute the bill etc.
• Packages available.
• Advance online bookings.
• Online Cancellation.
• List of Regular customers.
• Email facility.
• Feedbacks

   RECORD QUESTION FOR CLASS 10

Download (10 Questions )

11. Write the steps to create the tables in 

Library

TABLE NAME: LIBRARY_BOOKS
COLUMN_NAME	DATA TYPE
S.NO
BOOK_CODE
BOOK_NAME
BOOK_SUBJECT
BOOK_AUTHOR
BOOK_PAGES

TABLE NAME : LIBRARY_ISSUE
COLUMN_NAME	DATA TYPE
S.NO
ADM_NO
STU_NAME
STU_CLS
BOOK_CODE
ISSUE_DATE

School

TABLE NAME: STUDENT_DETAILS

TABLE NAME: STUDENT_PERSONAL_DETAILS

Add the columns as we written in the class work.

12. Create the Forms for the above databases.

13. Create the Reports for the above databases.

14. Write the Steps for usage of DDL and DML commands with examples. 

15. Create 10 Queries for the Library Database. (use INSERT, SELECT, UPDATE commands)

16. Create 10 Queries for the School Database. (use INSERT, SELECT, UPDATE commands)

Assignment images for Class IX

Class X FA 3 QUESTION PAPER

DOWNLOAD