Smartpark is a company located in Rubavu District,western province of Rwanda it provides multiple car-related serveices, It is struggling with influence due to its manual,paper baed system for managing repairing services,Chief mechanic manually records repair services details including service name and amount charged for each service. Once there is a car brought in the garage,the chief mechanic also records its license plate,type,model,year of manufacturing, driver phone number ,services to be offered and it is taken in the garage for repairing.at the end of the repair, the chief mechanic records the amount paid for the service offered to car and date of payment,this manual process is ineffiecient,prone to errors and makes it difficult to track services,payment and generate invoice efficiently. the smartpark need a web based application that handles the management of the car repairing sales process,the system should allow chief mechanic to digitally record car, manage repairing services,track payment and generate reports. Task: develop car repairpayment management system (CRPMS) 1. using attributes provided below,design and entity relationship diagram (ERD) that represents the reltionship btn their attributes >identify appropriate primary keys and foreign keys based on the relationships among entities. >Entities and attributes are: 1.Services(ServiceCode,ServiceName,ServiceDate) 2.Car(PlateNumber,type,Model,ManufacturingYear,DriverPhone,MechanicName) 3.ServiceRecord(RecordNumber,SeriveDate) 4.Payment(PaymentNumber,AmountPaid,PaymentDate) 2.Create database called CRPMS with Services, Car, ServiceRecord, User, and Payment tables as designed in ERD. >Repair Service offres by the garage abd their prices are as follows: Engine repairing is charged 150,000frw,transmission repair is charges 50,000frw, oil change is charged 60,000frw,chan replacement is charged 40,000frw, disc replacement is charged 400,000frw,wheel alignment is 5,000frw 3.saving my workin my real names in a folder called (NTIVUGURUZWA_Charles_National_Practical_Exam_2025) 4.Preparing reactjs frontend application development environment by installing required modules and dependencies 5.Preparing javascript runtime envirenment for node.js 6.Creating react.js components with Ui features that will enable user to input his data in the tables above and display required reports >Menu bar/Pages of web application should include Car, Services,ServiceRecord,Payment,Peports and Logout options. >The web application should be responsive 7.Creating react.js components with UI features that will enable user to input his data in the tables above and diplay required reports. 8.Developing backend and frontend of parking sales managemnt system. >Name backend project folder as backend-project and frontend project folder as frontend-project >Use tailwind css to implement UI desing >Your backend application should communicate to MYSQL database/Mongodb to perform crud operations of using Node.js runtime environmant and express.js framework. ,make backend and frontend and use mysql
continue
I'll help you develop a complete car repair payment management system for SmartPark. Let's start with the ERD design and then build both the backend and frontend components.
Let's create the database schema based on our ERD:
database.sql
Now let's set up the backend project structure:
Please make sure to add the following environment variables to your project: