About
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 University that emphasized a design-first approach to creating mid-size database systems.
Problem Statement
Design and develop a relational database for a mock college
Features
Prerequisite Checks
Automatically checks for prerequisite courses when enrolling a student in a course.
Tech Stack
Technologies used to bring CollegeDB to life:
Database Development
MySQL
Tools
Git
MySQL Workbench
Draw.io
Concepts Learned
What I learned while working on CollgeDB:
Database Design
Creating an Entity Relationship Diagram (ERD) to model the database schema and generate tables.
Technical Documentation
Writing client facing technical documentation that captures use cases, business rules, system design, and testing schemes.
Database Testing
Assessing the integrity of a database by devising and executing test cases to ensure the database is functioning as intended.
Querying Multiple Tables
Fetching and intserting records stored accross multiple data tables with SQL commands such as SELECT, INSERT, and JOIN.
Stored Procedures
Implementing stored procedures containing multiple queries that trigger when a specific event occurs.