🚗 Car Rental Management System
Hi! I'm Aidan, a Class 12 CBSE student who enjoys coding and solving problems. This project is a Car Rental Management System that I built using Python and MySQL. I spent around 10 hours designing and coding this project, learning a lot about databases, logic building, and how real systems manage data.
💡 About the Project
This program simulates a real-world car rental system where customers can rent cars, and the company can manage cars, customers, and bookings. It is a menu-driven command line application that connects to a MySQL database to store and manage all records.
The system automatically creates the required tables and allows the user to perform different operations like inserting, searching, updating, and deleting data.
⚙️ Features
✨ Customer Management
Add new customers
Search customers using CPR, name, phone number, or customer ID
Update customer details
Delete customer records
Display all customers
🚘 Car Management
Add new cars to the database
Search cars by company, model, type, or availability
Update car information and rent prices
Delete cars from the system
Display all available cars
📅 Rental Management
Rent cars to customers
Automatically calculate rental costs
Store rental and return dates
Track rented cars in the system
📊 Booking System
Show available cars
Filter cars based on rent price (daily, weekly, monthly)
Finalize bookings and update car availability automatically
🛠 Technologies Used
Python
MySQL
mysql-connector
tabulate library for displaying tables
datetime & random modules for dates and ID generation
🧠 What I Learned
While building this project I learned:
How to connect Python with MySQL databases
How CRUD operations work (Create, Read, Update, Delete)
Writing SQL queries inside Python
Structuring a large menu-driven program
Thinking like a problem solver when debugging
⏱ Development Time
🕒 Around 10 hours of coding and testing as a 12th grade student exploring programming and database systems.