Hotel System Management Analysis 9

HOTEL SYSTEM MANAGEMENT ANALYSIS 9 Hotel System Management Analysis Work-Related Project Analysis, Part I

Hotel System Management is software designed to assist in managing hotel operations, including maintaining customer records, managing room allocations, and processing transactions. It features a front-end developed in Visual Basic and a back-end database managed with Oracle. The system categorizes hotel rooms by standards and records relevant details for each, enabling efficient handling of customer information, billing, room allocation, and service management. It streamlines hotel operations by automating tasks such as billing, reservation management, and report printing, thereby improving efficiency and reducing errors. Additionally, the system is designed to be cost-effective, secure, and user-friendly, with features to prevent unauthorized access.

The project’s scope encompasses recording customer data, managing hotel services, processing billing, and facilitating room allocation. It records the goods and services offered—such as meals, beverages, room types, and staff details—and provides functionalities for printing receipts and bills. The software supports adding, updating, and deleting customer and hotel data, ensuring accurate and updated records. The system also enables reservations, room searches, and categorization of rooms based on quality standards. The design is based on an MDI form with options for inserting and updating data across six primary fields: hotel, customer, reservation, room, room category, and search.

A feasibility study was conducted examining technical, behavioral, and economic aspects. Technical feasibility ensured appropriate hardware (such as servers, storage, and printers) and software (Windows 7, Visual Basic, Oracle database) requirements are met for optimal operation. Behavioral feasibility assessed the availability of skilled personnel capable of using and maintaining the software, emphasizing training. Economic feasibility evaluated the cost-benefit ratio, comparing the expenses (hardware, wiring, facilities) to the potential benefits such as improved service delivery and operational efficiency, ultimately supporting the project’s viability.

The hardware requirements include a RAM between 128-512 KB, over 40 GB storage capacity, four Pentium processors, and hotel-specific printers for reporting and receipt printing. Software dependencies include Windows 7 Home Premium, Visual Basic for the front-end, and Oracle database for data management. Implementation demands integration of these components, with a focus on ensuring seamless operation between the interface and data storage layers.

The system architecture utilizes an MDI (Multiple Document Interface) main form with six primary modules, each designed to streamline specific tasks: hotel data entry, customer registration, reservation management, room search and details, room categorization, and a search function for querying the database. When a user interacts with any module, dropdown menus facilitate navigation, and data is entered and stored efficiently. The hotel form captures overall hotel information, while the customer form manages individual customer records. The reservation form handles booking details, including dates and customer IDs. The room form allows browsing and searching room details, and room categories help categorize rooms for better management. The search form allows users to quickly locate specific data in the system.

Analysis principles for system development include problem identification, creating prototypes to facilitate user understanding, documenting requirements and their origins, employing various system views, and eliminating ambiguity through iterative work. These principles aim to develop a robust, user-centric system that meets organizational needs and enhances operational workflows.

The data object diagram models the primary data entities in the system—hotels, customers, reservations, rooms, and categories—and illustrates how data flows and transforms within the database. This diagram assists in understanding data relationships, constraints, and the architecture necessary to support the system's functionality. It provides a high-level overview of data management, essential for ensuring data integrity and consistency during development and maintenance.

In conclusion, the hotel management system described here offers a comprehensive, user-friendly solution capable of handling complex hotel operations efficiently. Its integration of Visual Basic and Oracle ensures high performance and security, while the modular design facilitates ease of use and scalability. Proper development and user training have contributed to its successful deployment, with the system poised to deliver long-term benefits by improving operational efficiency and customer service quality.

References

  • 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, 120-130.
  • 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.
  • Sharma, R., & Sharma, P. (2019). Hotel management system using database management system. International Journal of Computer Applications, 175(6), 22-27.
  • Garg, S., & Paliwal, A. (2020). Cloud-based hotel reservation systems: Challenges and opportunities. Journal of Hospitality and Tourism Tech, 11(4), 627-639.
  • Kumar, V., & Singh, A. (2019). Enhancing hotel management with automated reservation systems. International Journal of Advanced Computer Science and Applications, 10(2), 55-62.
  • Patel, M., & Patel, R. (2021). Data security in hotel management systems. Journal of Information Security, 12(1), 11-20.
  • Chen, L., & Li, Y. (2017). Designing scalable hotel management software. International Journal of Software Engineering & Applications, 11(4), 45-58.
  • Singh, P., & Kumar, S. (2022). User-centered design in hospitality management software. Journal of Human-Centered Computing, 8(3), 65-78.

Related Assignments