/CS3200

Northeastern University CS3200 project repo

Primary LanguageJavaScript

Project Repo for CS3200.

This is for the Northeastern University Database Design Course.

Team members:

  • Sheryl Deakin
  • Oli Fishstein
  • Karan Marwah
  • Joey Wood

System Demo Video

System Setup Video

Steps to Run:

  1. Clone Our Entire Repo from Master

  2. Run MySQL (through XAMPP or command line tool) and Create a database using our ddl file as SOURCE for schema and our dml file as SOURCE for inserts

e.g.

  CREATE DATABASE dbdesignproject;

  USE dbdesignproject;
  
  SOURCE /Users/karanmarwah/Desktop/DatabaseHw/CS3200/project/ddl.sql;
  
  SOURCE /Users/karanmarwah/Desktop/DatabaseHw/CS3200/project/dml.sql;
  1. cd into our 'dbdesignproject' folder

  2. Run the command 'npm install' to install all dependencies

  3. Run the command 'brew install yarn' if you do not already have yarn on your system

  4. cd into the 'src folder

  5. open the server.js file. At the top edit the username, password, and database name to match the ones you used for step 2.

  6. in the 'src' folder run 'node server.js'. The backend should now be running on localhost:3000

  7. cd .. and return to the 'dbdesignproject' directory. Run 'yarn start'. The front end should prompt you to run on another port as 3000 is in use, type in 'y'

  8. once compilation has finished the frontend should be available at localhost:3001 in your browser