📄 INTEGRATED SITUATION

SwiftWheels Enterprises is a company that rents and sells vehicles located in Huye City, Southern Province, Rwanda. Currently, its daily operations are run manually. Core operations such as rent management, vehicle sales, reservations, vehicle returns, inventory tracking, payment handling, and employee coordination rely heavily on manual tools, including logbooks, paper forms, receipt books, and verbal communication.

As the business grows, the manual system has significant limitations. It is time-consuming, prone to errors, and struggles to provide real-time updates on vehicle availability, bookings, or sales. Employees find it manually track tasks and customer requests, which leads to operational delays, inefficiencies, and missed business opportunities.

SwiftWheels aims to digitalize its operations through a real-time, scalable web-based application that streamlines workflows, reduces errors, and enhances customer experience, driving efficiency, satisfaction, and sustainable business growth.

🚗 Task: Vehicle Rental & Reservation System (VRS)

As a full-stack developer, you are given 7 hours to develop the VRS web application using Node.js and React.js.

🛠️ Activities
1. ERD Design (on paper first)

Using the attributes below, design an Entity Relationship Diagram (ERD).

Entities and attributes
a. Customer
Full_Name
National_ID
Phone
Email
Address
b. Vehicle
Plate_Number
Brand
Model
Year
Vehicle_Type
Purchase_Price
Status
c. Reservation / Rental
Reservation_Date
Start_Date
End_Date
Reservation_Status
Rental_Date
Return_Date
Rental_Fee
Rental_Status
d. Users
UserName
Password
Role