Hospital Database Management System

Project Description

For this project, I designed a comprehensive database system for managing hospital operations. I created an entity-relationship diagram (ERD) to map out how patients, doctors, appointments, prescriptions, and departments all relate to each other. Then I built the actual database in SQL Server with proper normalization to avoid data redundancy. The system handles complex queries like tracking patient histories, managing appointment schedules, and monitoring prescription records. I included detailed documentation with a data dictionary explaining each table and relationship. This project really showcased my ability to think through complex data relationships and design efficient database structures that could work in a real healthcare setting. This was my first project in SQL.