ONLINE HOTEL MANAGEMENT SYSTEM
Table of ContentsTitle of the project. Introduction and objectives of the Project. Project category. Analysis (DFDs, ER Diagrams, Class Diagrams etc.) A complete structure Which includes : (i) Number of modules and their description to provide an estimation of the student’s effort on the project. Data Structures as per the project requirements for all the modules. Process Logic of each module. Report generation.

This is a Project work undertaken in context of partial fulfillment of MCA.I have tried my best to make the complicated process of Online Hotel Management System as simple as possible using Structured & Modular technique & Menu oriented interface. I have tried to design the software in such a way that user may not have any difficulty in using this package & further expansion is possible without much effort. Even though I cannot claim that this work to be entirely exhaustive, the main purpose of my exercise is perform each Employee’s activity in computerized way rather than manually which is time consuming. I am confident that this software package can be readily used by non-programming personal avoiding human handled chance of error. This project is used by two types of users i. ii. Online Users. Administrator (management of the Hotel).

Online users can see the required articles or news Administrator can maintain daily updates in the hotel records. Administrator is must be an authorized user. He can further change the password. There is the facility for password recovery, logout etc. 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, checkout 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 computerized the following functions that are performed by the system: Room Detail Functions Opening a New Room Modification to room assigned Check-in and check-out Detail Functions Admission of New customer Check-out of customer Room assigning related to customer’s need.

5

Statement of Customer Details Check-in customer Check-out customer Room Details Total number of Customers in the Hotel Individual customer Report

6

OBJECTIVEDuring 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 updation, 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...

YOU MAY ALSO FIND THESE DOCUMENTS HELPFUL

...DATABASE MANAGEMENTSYSTEM (DBMS)
A Database ManagementSystem (DBMS) is a software program that typically operates on a database server or mainframe system to manage structured data, accept queries from users, and respond to those queries. A typical DBMS has the following features (Stair and Reynolds, 2004):
 Provides a way to structure data as records, tables, or objects
 Accepts data input from operators and stores that data for later retrieval
 Provides query languages for searching, sorting, reporting, and other "decision support" activities that help users correlate and make sense of collected data
 Provides multi-user access to data, along with security features that prevent some users from viewing and/or changing certain types of information
 Provides data integrity features that prevent more than one user from accessing and changing the same information simultaneously
 Provides a data dictionary (metadata) that describes the structure of the database, related files, and record information
Most databases are operational databases, meaning that data going into the database is used in real time to support the ongoing activities of a business. A point-of-sale business accounting system is an example. As items are sold, the inventory database is updated and the inventory information is made available to the sales staff. The invoicing, order entry, and related...

...CLINIC MANAGEMENTSYSTEM
NOORUL HUDA BINTI NOORLY
This report is submitted in partial fulfillment of the requirements for the
Bachelor of Computer Science (Database Management)
FACULTY OF N ORMATION AND COMMUNICATION TECHNOLOGY
UNIVERSITI TEKNIKAL MALAYSIA MELAKA
2007
ABSTRACT
Clinic ManagementSystem for UTeM is a system that can help the clinic to manage
their daily activity. Thissystem help reduce the problems occur when using the
manual system. This system enables doctors and clinic assistant to manage patient
records, medicine stock, and appointment and produce reports. The system is develop
due to the problems that exist when using the manual system. Data inconsistency,
data m x with other data and problem regarding reporting is the main problem that the
i
user is facing. Due to that, this system is develop to overcome the problems. This
system is easy and simple to use by the user. Other than that, the system is userfriendly and it can help the clinic to manage their activity and at the same time
overcome the problem.
ABSTRAK
Clinic ManagementSystem (CMS) adalah sistem yang boleh membantu klinik dalam
menjalankan aktiviti harian mereka. Sistem ini membantu mengurangkan masalahmasalah yang dihadapi apabila...

...Fie lFile Organization Terms &amp; Conceptscomprises a record; A computer system organizes data in a hierarchy t
A computer system organizes data in a hierarchy that starts with bits and bytes and progresses to fields, records, files, and databases.
* A bit represents the smallest unit of data a computer can handle.
* A group of bits, called a byte, represents a single character, which can be a letter, a number, or another symbol.
* A grouping of characters into a word, a group of words, or a complete number (such as a person’s name or age) is called a field.
* A group of related fields, such as the student’s name, the course taken, the date, and the grade, comprises a record.
* A group of records of the same type is called a file.
* A group of related files makes up a database.
* A record describes an entity.
* An entity is a person, place, thing, or event on which we maintain information.
* An order is a typical entity in a sales order file, which maintains information on a firm’s sales orders.
* Each characteristic or quality describing a particular entity is called an attribute.
* For example, order number, order date, order amount, item number, and item quantity would each be an attribute of the entity order.
* Every record in a file should contain at least one field that uniquely identifies instances of that record so that the record can be retrieved,...

...www.Vidyarthiplus.com
VIDYARTHIPLUS - ANNA UNIVERSITY ONLINE STUDENTS COMMUNITY
III SEMESTER - B.E – COMPUTER SCIENCE AND ENGINEERING
QUESTION BANK - CS6302 DATABASE MANAGEMENTSYSTEMS
UNIT I
1. What are the disadvantages of file processing system?
2. Explain the basic structure of a relational database with an example.
3. What do you mean by weak entity set?
4. Give example for one to one and one to many relationships.
5. What is the need of normalization?
6. Write a note on functional dependencies.
7. Who is a DBA? What are the responsibilities of a DBA?
8. What is a data model? List the types of data models used.
9. What are the components of storage manager?
10. What is a data dictionary?
11. What is an entity relationship model?
12. Define single valued and multi valued attributes.
13. What are stored, composite and derived attributes?
14. What is meant by the degree of relationship set?
15. Define weak and strong entity sets?
16. Explain the two type’s o f participation constraint.
17. Define the two levels of data independence.
18. Write down any two major responsibilities of a database administrator.
19. Define irreducible sets of dependencies.
20. Define the normal forms.
16/10/8 Marks Questions
1. With a neat diagram, explain the structure of a DBMS.
2. What is data integrity? Explain the types of integrity constraints.
3. Explain 1NF, 2NF, 3NF and BCNF with suitable example.
4. What are the pitfalls in relational...

...How does a relational database organize data,and how does it differ from an object-oriented database?
The rational database is the primary method for organzizing and maintain data today in information system. It organizes data in two-dimensional tables with rows and columns called elations. Eachtable contains data ab out an entity and its attributes. An entity relationship diagram graphically depicts the relationship between entities in a relations database. An object-oriented database managementsystem stores data and procedures that act on the data as objects and it can handle multimedia as well as characters and numbers.
2-What are the principles of a database managementsystem?
A DBMS consists of software that permits centralization of data management do that businesses have a single consists source for all their data needs. The principle capabilities of a DBMS includes a data definition capability, a data dictionary capability, and a data manipulation language.
3-What are the principal tools and technologies for accessing information from databases to improve business performance and decision making?
A data warehouse consolidates current and historical data from many different operational systems in a central database designed for reporting and analysis. Data warehouse support miltimensional data analysis also knows as online analytical processing.Text mining...

...DBM405 (Database ManagementSystem)
Facilitator Anup Majumder-University of Phoenix Online
Abstract
The research that I have done for this individual assignment where I need to provide a brief explanation of OLAP, Data Warehouse and Data Mart, Three-tier architecture and ASP was through a research online. I found that most of these acronyms for computer terminology are hard to find when the meanings that apply to your subject or acronym you are un-aware of it. In conclusion all the above words are related one to each other.
Let me start this paper providing a shot briefing about how hard was for me finding most of the explanation of these four terminologies that I will be explaining below.
OLAP is the first word that I will define in my paper. OLAP is an acronym for On-Line Analytical Processing. It is an approach to quickly providing the answer to complex database queries. Is used in today business for reporting sales, marketing, management reporting, data mining and similar areas.
The main reason of using OLAP to answer queries is speed. Relational databases store entities in discrete tables if they have been properly normalized. This structure is good for operational databases but for complex multi-table queries is comparatively slow. A better model for querying but worse for operational use is the dimensional database.
OLAP take a snapshot of a relational database and restructures it into dimensional...