Hospital Data Management System – SQL Project

🔍 Project Showcase | SQL-Based Hospital Data Management System 🏥💾
I’m excited to share my latest project where I designed and implemented a Hospital Data Management System using MySQL, XAMPP, and CMD. This project focused on managing and analyzing healthcare data such as patients, doctors, appointments, and treatments through a fully functional relational database system.
🎯 Objective:
To design a relational database system that simplifies the management of hospital operations — from patient records and doctor details to appointments and treatments.
🛠️ Tools & Technologies:
-Database: MySQL
-Interface: XAMPP, CMD
-Techniques Used: DDL, DML, Joins, Subqueries, Aggregate & String Functions, Views, Constraints
-Design: Entity-Relationship (ER) Diagram to model relationships between tables
📊 Project Highlights:
-Created normalized tables: PATIENT, DOCTORS, APPOINTMENTS, TREATMENT
Executed advanced SQL queries: INNER JOIN, LEFT/RIGHT JOIN, GROUP BY, ORDER BY, DATEDIFF, etc.
-Implemented foreign keys and data integrity rules
-Used functions like CONCAT, ROUND, SUBSTRING, REPLACE, and LENGTH to derive insights
-Designed views for simplified access to critical data (e.g., cardiologists with experience)
✅ This project sharpened my practical SQL skills and gave me real-world exposure to managing relational databases in the healthcare domain.