Work-Related Project Analysis, Part 2

Hotel System Management Analysis

Work-Related Project Analysis, Part I

1.0 Introduction

Hotel System Management is software that has been designed to aid in managing a hotel. This software helps in the managing and maintaining the customers' records together with the number of rooms in the hotel. It is designed in a way that it has two ends which are the front end to Visual Basic and the back end which is the Oracle Database. The hotel rooms are of different standards hence records of each room standard if kept differently (Lalvani & Suh, 2018). This hotel management system can be easily managed by any hotel employ allocated for proper transactions and customer’s information entry.

2.0 Nature and Scope of the Project

Hotel system management software has been designed in a way that customers’ records can be added according to the number of customers visiting and purchasing goods and services from the organization and erases the customer’s record when he or she vacates the hotel after offering the payments. The system software prints receipts according to the information fed by the user and calculates the total bill used by each and every customer.

The software contains all the records of goods and services that are in the hotel. These goods and services may include; meals and beverage offered, types of hotel rooms, hotel employees together with the hotel management team. Apart from printing and recording of bill services, the system can also allocate hotel rooms to the customers and analyze the services that will be undertaken in each room. Lastly, this system is cost effective and offers quality work and it’s also designed in a way that it can detect and revoke operations done by a wrong user (Masters & Gordon, 2018).

3.0 Feasibility Study

A feasibility study of this project software system has been conducted in order to select a system that performs best to ease the working ability of the organization. This study has been done in three types;

1. Technical feasibility study

2. Behavioral feasibility study

3. Economical feasibility study

Technical feasibility

This type of study has been conducted to select and set aside hardware that is well designed for the system software hence giving it a smooth working environment to provide maximum work efficiency.

Behavioral feasibility

This project has considered the cost of semi-skilled and skilled personnel who can be educated and trained on the new ways of handling or using the software.

Economical feasibility

In this type of study, this project considers the costs of each customer together with that of the proposed system and compares and contrasts with the costs used by the management to meet the employees' costs. These costs may include; the supply cost, cost of the system’s hardware, wiring costs, lightning cost, facility costs and lastly the operating costs (Lim et al, 2018).

4. 0Project Requirement

This project requires various hardwares and softwares for better functioning of the hotel management software system.

Hardware requirement

 A RAM of 128 to 512 KB

 A data storage of above 40 GB

 Four Pentium processor

 Hotel printer for producing reports and printing receipts

Software requirement

 The home premium of windows 7

 Front-end net which is Visual Basic

 The back end which is Oracle database

Project Implementation

For the project to be implemented, the front end that is Visual Basic and back-end Oracle database are required.

5.0Hotel System Design

This system has been designed in a way that it has the main form as MDI Form. This MDI form contains six fields which include; hotel, customer, reservation, room, room category, and search. When a user points and clicks the cursor on any of the fields, a menu that has to drop down appears and on left clicking the open command, the file automatically opens (Lalvani & Suh, 2018).

· Hotel

This form on the database is used when the user wants to insert an additional hotel. For this case the user should fill the name of the hotel, ID number of the hotel and the main address. After he or she fills all the required entries the save button is clicked and the new hotel information record will be added and saved on the database.

· Customer

The customer form is used when a new customer is being added on the customer records. The name of the customers, the customers’ ID number and the main addresses are filled in the new customer entry. After finishing one click on the submit button and the information of the new customer will be recorded on the database.

· Reservation form

In this form, the system user inserts details of customer reservation. These details may include; the reservation date, reservation ID, hotel ID number, customer ID, customer’s date of arrival among others.

· Room

In this form, a user can search the hotel rooms and their details such as the room category or the room number. After completing with the details entry the user clicks the search button in order to view the types and details for the room that he has been looking for.

· Room Category

This form is used by the user by inserting details of the hotel room category like the category name, ID and the beds' numbers. After completion of filling all the required entries, the save button is clicked by the user and the details pertaining to the type of hotel rooms is recorded on the database.

· Search form

This form is used by the user when he wants to look for any information in the database about the forms. When the form is inserted on the search book and found a message will appear indicating that the result has been found in the database.

System analysis principles

• Before creating the analysis model identify the problem

• Create a prototype and help the users learn how to interact with the machine will occur

• Record each requirement and its origin

• Use various views such as model, data building and functions of each requirement

• Eliminate the ambiguity by working.

6.0Diagram of the Entity Relationship

A data object description can help in describing each data object found in the diagram of entity-relationship. This data flow diagram aids in providing an induction on how data transformation takes place when moving through the system (Masters & Gordon, 2018).

Data Objects

These are objects that represent any information that can be understood by the software. The data object can be used to name, describe and make references on an instance in a different table.

This entity-relationship diagram gives a general overview of the details in the system software database.

7.0Conclusion

This project is user-friendly designed and it can widely provide features interface that a hotel management system requires. The quality of this project is very high and it provides response very quickly and a high level of security is maintained. Visual Basic and the Oracle database are well maintained (Loon et al, 2018). Proper development of the software prototype and making the users understand how the system works has made this project a success.

Reference

Lalvani, A., & Suh, J. S. (2018). U.S. Patent Application No. 15/698,428.

Lim, W. M., Teh, P. L., Ahmed, P. K., Cheong, S. N., Ling, H. C., & Yap, W. J. (2018). Going keyless for a seamless experience: Insights from a unified hotel access control system. International Journal of Hospitality Management, 75, 105-115.

Loon, W. W., Aung, H., & Tin, H. H. K. (2018). Learning the Requirements Engineering Process of the Online Hotel Reservation System. International Journal of Emerging Research in Management and Technology, 7(8), 13-19.

Masters, G. W., & Gordon, C. (2018). U.S. Patent No. 9,922,476. Washington, DC: U.S. Patent and Trademark Office.