A comprehensive Hotel Management System built using Python (Tkinter) for the GUI and MySQL for database management. This project provides a complete digital solution for handling hotel operations such as customer registration, room booking, room inventory management, and billing.
- Auto-generated reference number for each customer
- Full personal detail entry with ID proof handling
- Search, filter, update, and delete customer records
- Integration with customer and room databases
- Automatic bill generation including tax
- Meal plan options (Breakfast, Lunch, Dinner)
- Real-time room availability check
- Stay duration calculation
- Add, update, or remove rooms from inventory
- Categorize rooms by type (SINGLE, DOUBLE, LUXURY)
- Floor-based room management
- Multi-filter search across customer and booking records
- Instant, real-time result display
- Displays hotel contact info with animated effects
- Company branding and logo display
- Frontend: Python
Tkinter(GUI) - Backend: Python
- Database: MySQL
- Tools Used: MySQL Workbench
| Field | Type | Description |
|---|---|---|
| Ref (PK) | VARCHAR | Unique customer ID |
| Name | VARCHAR | Customer name |
| Mother | VARCHAR | Mother's name |
| Gender | VARCHAR | Gender |
| PostCode | VARCHAR | Postal code |
| Mobile | VARCHAR | Mobile number |
| VARCHAR | Email address | |
| Nationality | VARCHAR | Nationality |
| IdProof | VARCHAR | Type of ID provided |
| IdNumber | VARCHAR | ID number |
| Address | TEXT | Full address |
| Field | Type | Description |
|---|---|---|
| floor | INT | Floor number |
| roomno (PK) | VARCHAR | Unique room number |
| roomType | VARCHAR | Room type (e.g. SINGLE) |
| Field | Type | Description |
|---|---|---|
| contact (FK) | VARCHAR | Linked to customer mobile |
| checkinDate | DATE | Check-in date |
| checkoutDate | DATE | Check-out date |
| roomType | VARCHAR | Type of room |
| room | VARCHAR | Room number |
| meal | VARCHAR | Meal plan |
| noOfDays | INT | Number of stay days |
- Input validation with user-friendly error messages
- Try-except blocks for database operations
- Graceful handling of unexpected errors
- Transaction management (commit/rollback)
This Hotel Management System demonstrates:
- Real-world business logic implementation
- Clean separation of concerns via a three-tier architecture
- Integration of GUI and database for an end-to-end software solution
- Scalable and user-friendly interface
- Python 3.x
- MySQL Server
- MySQL Connector (
pip install mysql-connector-python)
- Clone the repository:
git clone https://github.com/yourusername/hotel-management-system.git cd hotel-management-system