← Back to Projects

Project Links

View Source Code

Table of Contents

Healthcare & Pharmaceutical Database System

Can a database automatically flag dangerous drug combinations the moment a prescription is written? This project answers that question — a 10-table relational system with real-time safety triggers, pharmaceutical pricing analysis, and fulfillment tracking, built with MySQL and Python.

🏥 Healthcare & Pharmaceutical Database System (MySQL & Python)

Role: Database Architect & SQL Developer

Tech Stack: MySQL 8.0, Python (Pandas, mysql-connector), Relational Modeling (3NF)

Overview

Designed and implemented an end-to-end relational healthcare database modeling interactions between patients, physicians, pharmacies, pharmaceutical manufacturers, and drug formularies.

Key Highlights & Technical Challenges

  • Real-Time Clinical Safety (Database Trigger): Implemented an automated MySQL trigger (AFTER INSERT ON prescriptions) that monitors incoming prescriptions against known contraindicated drug interactions (adverse_interactions), automatically logging real-time flags into an alerts audit table.
  • Supply Chain & Pricing Analytics: Engineered multi-tier CTE queries comparing wholesale manufacturer contract pricing against retail pharmacy markups, tracking margin spreads per medication.
  • Turnaround Lead-Time Analysis: Applied SQL temporal functions (TIMESTAMPDIFF) to measure average fulfillment latency between prescription issuance and pharmacy dispensing.
  • High-Risk Provider Profiling: Identified outlier prescribing behavior by ranking physicians responsible for generating adverse drug reaction alerts.

View GitHub Repository → | View ER Diagram →