The Hotel Management System is a Python-based application that simplifies hotel operations by integrating customer management, room details, food orders, and cost calculation with a MySQL backend. It’s designed to help hotel staff manage essential tasks efficiently while maintaining data integrity through a secure database.
- Customer Management: Add, update, and delete customer records, including name, Aadhaar number, phone number, address, and membership status.
- Room Details: Manage room availability, rent, and other details.
- Food Orders: Track customer food orders and add them to the final bill.
- Cost Calculation: Automatically calculate total costs, including room rent, food orders, and membership benefits.
- Database Integration: All information is stored in a MySQL database for persistence.
- Python: Application logic.
- MySQL: Database management.
- MySQL Connector for Python: For Python-MySQL communication.
-
Clone the repository:
git clone https://github.com/Anishka2006/hotel-management-system.git
-
Install dependencies:
pip install mysql-connector-python
-
Set up MySQL database:
- Create a database named
HotelManagement. - Create the necessary tables using the provided SQL scripts or based on the code structure.
- Create a database named
-
Run the application:
python PROJECT_fixed.py
- Start the application and choose from the menu:
- Add, update, or delete customer details.
- Manage room details and food orders.
- Calculate final cost based on room rent, food orders, and membership.
- The system will interact with the MySQL database to store and retrieve data efficiently.
- Adding a Graphical User Interface (GUI) for better user interaction.
- Integrating a payment gateway for handling online transactions.
- Expanding the system to manage multiple hotel branches.
Feel free to fork this project, submit issues, or contribute through pull requests. All contributions are welcome!