DESIGN OF WEB SYSTEM WITH DATABASE FOR ONLINE HOTEL ROOM BOOKING BASED ON MVC ARCHITECTURE
DOI:
https://doi.org/10.35546/kntu2078-4481.2025.2.2.16Keywords:
web system, hotel, database, MVC, MySQLAbstract
The article presents an approach to the design and development of a web system with a database for online hotel booking based on the MVC architecture. Existing solutions in the field of online hotel booking are analyzed, which indicates that despite the presence of numerous systems, common problems remain the complexity of integration with payment services and external APIs, insufficient level of personalization, as well as optimization of performance during high load. Therefore, the aim of the work was to create an effective, user-friendly and secure web system with a database for online hotel booking based on the MVC architecture, which automates the hotel booking process and simplifies customer data management.To implement the user interface, the React library was used, which provides dynamic and adaptive display of information, facilitating user interaction with the system. The server part is built on the Node.js platform using the Express framework, which allows you to organize request routing, business logic processing and secure user authorization. The MySQL database management system is used to store data, which is responsible for the integrity, speed of access and structured storage of information about users, reservations, rooms and their statuses.The developed web system with a database for online hotel room booking takes into account the main functional requirements of modern online booking services: user registration, booking management, viewing available rooms and managing personal accounts. The MVC architectural approach used ensures the separation of logic, presentation and data work, which facilitates further support, expansion of functionality and scaling of the system.The proposed system has the potential for further development, in particular for the implementation of algorithms for personalized recommendations, expanding payment options and increasing data protection.
References
Vernekar S. R., Kumar L., Kalnoor G. Hotel Reservation App Integrated with Docker and Jenkins. 2024 International Conference on Emerging Technologies in Computer Science for Interdisciplinary Applications (ICETCS), Bengaluru, India, 22–23 April 2024. 2024. URL: https://doi.org/10.1109/icetcs61022.2024.10544088 (дата звернення: 27.05.2025).
Understanding the Effects of Reservation Systems and Online Transaction Capacity on the Competitiveness of Travel Agencies / M. Işkın et al. European Journal of Tourism, Hospitality and Recreation. 2024. Vol. 14, no. 1. P. 55–70. URL: https://doi.org/10.2478/ejthr-2024-0004 (дата звернення: 27.05.2025).
Проєктування баз даних вебсистем: вебтехнологія використання вебфреймворку Django та системи керування базами даних MySql / Р. Багрій та ін. Наука і техніка сьогодні. 2025. № 4(45). URL: https://doi.org/10.52058/2786-6025-2025-4(45)-1083-1097 (дата звернення: 27.05.2025).
Datalogic Model for Determining the Clients Compatibility Based on Questionnaires Data Analysis by Artificial Intelligence Means / D. Zhuk et al. Innovative Solutions in Science: Balancing Theory and Practice. Proceedings of the 1st International scientific and practical conference. 2024. Pp. 80–85 (дата звернення: 27.05.2025).
Comparative Study: Performance of MVC Frameworks on RDBMS / M. H. Rahman et al. International Journal of Information Technology and Computer Science. 2024. Vol. 16, no. 1. P. 26–34. URL: https://doi.org/10.5815/ijitcs.2024.01.03 (дата звернення: 27.05.2025).
Patel K. A Comprehensive Booking Management System Using Laravel: B.Tech Thesis / K. Patel; advisor: M. Prajapati. Parul University, Vadodara, India, 2025. URL: https://www.researchgate.net/publication/389701325_A_Comprehensive_Booking_Management_System_Using_Laravel (дата звернення: 27.05.2025).
Nsama L., Neene N. Design and Development of an Online Room Reservation System for Silverline Guest Lodge / L. Nsama, N. Neene. The International Journal of Multi-Disciplinary Research. 2021. URL: https://www.researchgate.net/publication/378867456_Design_and_Development_of_an_Online_Room_Reservation_System_for_Silverline_Guest_Lodge (дата звернення: 27.05.2025).
Kochura V., Loktikova T., Kushnir N. Hotel and accommodation booking management platform for travel in Ukraine. Modeling, Control and Information Technologies. 2024. No. 7. P. 125–127. URL: https://doi.org/10.31713/ mcit.2024.034 (дата звернення: 27.05.2025).
Проєктування структури бази даних для інтелектуальної системи нейромережевого виявлення та локалізації на фотозображеннях ділянок із залишками зруйнованих будівель / О. Мазурець та ін. Наука і техніка сьогодні. 2025. № 4(45). URL: https://doi.org/10.52058/2786-6025-2025-4(45)-1242-1258 (дата звернення: 27.05.2025).
Реляційна даталогічна модель для прикладного аналізу репрезентативності навчальних тестів засобами обробки природної мови / О. Мазурець, О. Тищенко, Д. Гардиш. Наука і техніка сьогодні. 2025. № 13(41). URL: https://doi.org/10.52058/2786-6025-2024-13(41)-1129-1142 (date of access: 27.05.2025).
Datalogic Relation Model for Automated Evaluating the Semantic Integrity of Test Tasks Sets by Machine Learning Means / D. Hardysh et al. Innovative Solutions in Science: Balancing Theory and Practice. Proceedings of the 2nd International Scientific and Practical Conference. 2024. Pp. 114–125.
Даталогічна модель бази даних для виявлення гендерної приналежності за SVM-аналізом дописів інтернет-мереж з використанням об’єктно-орієнтованого проєктування / О. Мазурець та ін. Herald of Khmelnytskyi National University. Technical sciences. 2024. Т. 337, № 3(2). С. 197–204. URL: https://doi.org/10.31891/2307-5732-2024-337-3- 29 (дата звернення: 27.05.2025).
Datalogic Projecting for Applied Adaptive Semantic Testing / O. V. Mazurets. Heritage of European Science. International collective monograph. Monographic series «European Science». Karlsruhe, Germany. 2024. Book 27. Part 3. Chapter 8. P. 147–156. ISBN 978-3-98924-038-4
Model for Image Recognition by Convolutional Neural Network Using Cloud Services / O. Mazurets et al. Proceedings of XXII International Scientific and Practical Conference “Modern Scientific Research: Theoretical and Practical Aspects”. 2024. Pp. 64–68.
Relation Datalogic Model for Determining the Diagnosis Based on Intellectual NLP-analysis of Symptom Description / O. Mazurets et al. Proceedings of XV International Scientific and Practical Conference “Innovative Development: Synthesis of Scientific Approaches in Various Fields of Research”. 2024. Pp. 61–66.
