Home Blog About Me Resume

SQL Database Management for a Medical System

By Holden Weber

Project Overview and Motivation

As part of my SQL and database management coursework, I developed a relational database system to manage essential data for a medical practice. This project provides a complete, structured approach to organizing physician, patient, visit, and payment information, ensuring both accuracy and efficiency. The purpose of this database is to facilitate daily operations in a healthcare setting, such as tracking patient visits, recording financial transactions, and maintaining physician information.

By designing this SQL-based system, I aimed to create a scalable solution that can handle the various needs of a medical practice. The database includes features like automated balance updates, salary tracking for physicians, and reports based on patient diagnoses. This project demonstrates how SQL and relational database design can streamline complex data management tasks, making it ideal for environments where data accuracy and accessibility are crucial.

Entity-Relationship Diagram (ERD)

Below is the Entity-Relationship Diagram (ERD) for the medical system database. It shows how various entities such as patients, physicians, and visits relate to one another:

Entity-Relationship Diagram (ERD) for the Medical System

Unified Modeling Language (UML) Diagram

The UML diagram for this project illustrates the structure and behavior of the system, providing a blueprint for its implementation:

Unified Modeling Language (UML) Diagram for the Medical System