The final project for Database Theory and Design. It provides an easy way for users to view a set of events data for a transportation system.
Make sure NPM is installed
Run “git clone https://github.com/KINGTUT10101/TransportationEventsProject.git”
Run “cd TransportationEventsProject”
Run “npm install”
Run “cd client”
Run "npm install" again
Run "cd ../server"
Run "npm install" once again
Download and install pgAdmin
Create a database named "transportProject" with the password set to "password"
Run the database creation script
Import the CSV files found in the database/raw_data folder
Download the events XML file from D2L and place it into the database/raw_data folder
Run "cd database/scripts/import_events_data"
Run "node --max-old-space-size=4096 transferToDB.js"
Wait for the script to finish. It may take a while
Run “npm run dev” in the project's root directory
Connect to localhost:3000 in your browser
Run “npm run client” in the project's root directory
Connect to localhost:3000 in your browser
(It's recommended that you do this before running the backend. This will update the static frontend files that the backend will return to you)
Run "npm run build" in the project's root directory
Run “npm run server” in the project's root directory
Connect to localhost:5000 in your browser