A valid NodeJS installation is required to run the API server.
First, set up database
-
The database must first be initialized by running the A5-Create.sql and A5-InitialData.sql scripts within the src/DB-erd-scripts folder.
-
After database initialization, execute the trigger and procedure creation scripts (https://github.com/YifanEvaWang/Car-Database-Management-System/blob/master/src/DB-ERD-SCRIPT/triggers_and_procedures/All_PROC_AND_TRIGGER.txt).
Then, follow the instructions below to start the API server and the user interface
-
In the a5 folder, navigate to the WEBSERVICE subfolder and install the web server with npm install.
-
Navigate to src/WEBSERVICE/config/dbConfig and fill in your database information.
-
Start the server by using npm start.
-
The web server will proceed to run on port 8000.
-
Navigate to the src/UI folder and install the UI using npm install
-
Start the user interface by using npm start
-
The user interface will be accessible on localhost:3000
Demo https://www.youtube.com/watch?v=jTSjqxzGw9k (Voice volume might be a bit small, sorry!!)