This is a project I worked on in a database modeling class of a real-world buisness scenario where the director and manager of a medical therapy managment (MTM) program would like to have an online database and dashboard created with the pharmacist team's KPIs that show individual performance as well as team performance. It includes the business requirements document, a design document, and a db schema for an online database that replaces a reporting process where a team of analyst sends KPI reports to the director and manager via email with spreadsheets files.
BRD_PharmacistKPI_DatabaseModel_v1.0.pdf: This is the business requirements document.
DD_PharmacistKPI_DatabaseModel_Schema_v1.0.png: This is an image file of the database schema.*
DD_PharmacistKPI_DatabaseModel_Script_v1.0.sql: This is the SQL script to create the database and tables.
DD_PharmacistKPI_DatabaseModel_v1.0.pdf: This is the design document.*
*Note: There are a couple of column changes to the Patient and Appointments table in the BRD and DD that are not reflected in the schema. I currently do not have access to Visio to update the schema.