This database project for CST363: Introduction to Database Management focuses on the design and implementation of a relational system tailored for pharmacy operations. I architected a schema to support the complex relationships between patients, providers, and multi-location inventories. The project includes:

Entity Modeling: Architected a schema around five core entities: Doctor, Patient, Drug, Pharmacy, and Prescription.
Relational Integrity: Implemented junction tables such as prescription_refill to track medication history and refills.
Financial Tracking: Developed a drug_cost module to manage dynamic pricing and cost determination for various pharmaceuticals.
Full-Stack Integration: Demonstrated programmatic database access using JDBC to interface between a Java web application and the SQL backend.
SQL Optimization: Wrote optimized queries to handle complex transactions between patients, doctors, and multiple pharmacy locations.

The project demonstrates a deep understanding of relational database design, normalization, and the practical application of SQL in a healthcare context. Relational integrity and normalization are the foundations of building reliable, scalable systems for sensitive healthcare data.

Project Deliverables