This file contains instructions to set up your local MySQL database.
Download and install the MySQL Community Server and MySQL Workbench: https://dev.mysql.com/downloads/ (the script is tested with MySQL v 8.3.0)
Connect to the MySQL Workbench, copy and run the script within university-mysql.sql file to create a new database called university.
The script will drop the database if it exists, then create a new database and tables.
Lastly, copy and run the script in the populate-university-db file to add data to the tables.