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.

Table of Contents

• Run Locally
• Documentation
• Entity Relationship Diagram
• Database Model

Run Locally

Prerequisites

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

Clone Project

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

Create database

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.

Run SQL script

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.

Documentation

Access the complete documentation for CollegeDB here

Entity Relationship Diagram

Database Model