The Car Rental System is designed to automate the process of renting cars to customers, providing an easy-to-use platform for managing car rentals. The system handles customer reservations, car availability, rental agreements, and payment processing. It also provides administrators and employees with tools for managing the fleet, reviewing customer feedback, maintaining cars, and generating reports.
- Organization Introduction
- key Features
- Problem of Organization
- Solution
- Entities and Attributes
- Entity-Relationship Diagram
- Physical ERD
- Relational Schema
Car Rental System is a car rental company that provides rental services to customers in various locations. The company has a fleet of cars that are categorized based on their make, model, and features. Customers can make reservations for cars, which are then picked up at a rental location. Rental agreements are made with customers and include details such as rental dates, rental location, and payment information. The company also provides additional features, such as GPS and car seats, for an additional fee.
1. Reservation Process: Customers can make reservations online or by phone, selecting from available cars and choosing pickup/return times and locations.
2. Rental Agreements: Details like rental periods, locations, and customer information are captured in the agreement, alongside optional features (e.g., GPS, child seats).
3. Car Inventory Management: Administrators can manage the fleet, adding or removing cars, and updating their status or availability.
4. Customer Management: Employees can manage customer accounts, track their rentals, and provide support during the rental process.
5. Payments: Customers are charged based on their selected cars, rental period, and additional features. The system supports multiple payment methods.
6. Car Maintenance: The system tracks maintenance records for each car, ensuring vehicles are in optimal condition before being rented out.
The manual booking process in a car rental system is time-consuming, error-prone, and limits access to booking services. It involves manual data entry, paper-based forms, and phone calls, leading to inefficiencies and potential mistakes in bookings.
AUTOMATED BOOKING SYSTEM
Our car rental system addresses the limitations of manual booking by implementing an automated system, enabling customers to make 24/7 reservations online or via a mobile app. It offers real-time vehicle availability, automated confirmations, and easy reservation modifications or cancellations. Secure online payment integration enhances efficiency, accuracy, and customer convenience, streamlining the overall booking process for both customers and the rental company.
1. ADMIN: ADMINID (PK), NAME, CONTACT DETAILS, EMAIL, PASSWORD
2. EMPLOYEE: EMPLOYEEID (PK), ADMINID (FK), NAME, EMAIL, CONTACT DETAILS, PASSWORD
3. EMPLOYEE ACCESS: ACCESSID (PK), EMPLOYEEID (FK), ACCESS LEVEL
4. CUSTOMER: CUSTOMERID (PK), NAME, CONTACT DETAILS, DRIVER'S LICENSE NUMBER
5. CAR REVIEW: REVIEWID (PK), EMPLOYEEID (FK), CUSTOMERID (FK), CARID (FK), REVIEW COMMENTS
6. RENTAL AGREEMENT: AGREEMENTID (PK), CUSTOMERID (FK), CARID (FK), PAYMENTMETHODID (FK), STATUSID (FK), RENTALEXTENSIONID (FK), RENTAL PRICE, RENTAL LOCATION, INSURANCE POLICY DETAILS, DAMAGE REPORTS
7. ORDER: ORDERID (PK), CUSTOMERID (FK), CARID (FK), ORDER DATE, RENTAL RATE, RENTAL LOCATION
8. CAR: CARID (PK), CARCATEGORYID (FK), CARAVAILABILITYID (FK), MAKE, MODEL, YEAR, COLOR, REGISTRATION NUMBER
9. CAR MAINTENANCE: MAINTENANCEID (PK), CARID (FK), MAINTENANCE DATES, TASKS PERFORMED, ASSOCIATED COSTS
10. CAR CATEGORY: CATEGORYID (PK), CATEGORY NAME, DESCRIPTION
11. DAMAGE REPORT: DAMAGEREPORTID (PK), CARID (FK), REPORT DESCRIPTION, REPAIR COST
12. CAR AVAILABILITY: AVAILABILITYID (PK), CARID (FK), AVAILABILITY STATUS, BOOKING DATES
13. RENTAL STATUS: STATUSID (PK), STATUS
14. RENTAL EXTENSION: EXTENSIONID (PK), AGREEMENTID (FK), EXTENSION DATES, STATUS
15. LOCATION: LOCATIONID (PK), CARID (FK), LOCATION NAME, ADDRESS
16. PAYMENT METHOD: PAYMENTMETHODID (PK), METHOD TYPE
17. INSURANCE: INSURANCEID (PK), POLICY ID, COVERAGE DETAILS
18. TRANSACTION: TRANSACTIONID (PK), AGREEMENTID (FK), TRANSACTION DATE, AMOUNT
19. CAR IMAGE: IMAGEID (PK), CARID (FK), IMAGE URL
20. DISCOUNT: DISCOUNTID (PK), PERCENTAGE, CATEGORYID (FK), DISCOUNT CODE
