A relational database that stores and manages data pertaining to the operations of a mock college. CollegeDB was a milestone based capstone project in my Intro to Database Systems course at San Francisco State Uniiversity that emphasized a design-first approach to creating mid-size database systems.
In order to successfully run an instance of CollegeDB in your local machine, please ensure the following are installed:
- MySQL Community Server (Version 8.0 )
- MySQL Workbench
You may view this YouTube tutorial to help guide the installation process
Once MySQL is up and running, go ahead and clone this repository to your local machine
git clone https://github.com/amron98/CollegeDB
Go to the project directory
cd CollegeDB
There are two options to creating the CollegeDB in your local machine. The first, and most direct. is to run the forward engineered SQL script to create the database as well as the tables with their associated relationships.
Using terminal, connect to MySQL using your credentials and run the SQL script
mysql -u <username> -p <CollegeDB> < <./CollegeDB.sql>
You will then be prompted to enter your password
Once the connection has been established, this command creates a new database, "CollegeDB" and runs the SQL script inside of it. In this case, it creates all of the tables and their relationships.
Access the complete documentation for CollegeDB here