Hospital Management Database Project

Overview

This project is a Hospital Management Database System developed using MySQL. The project manages and analyzes healthcare-related data including patients, doctors, admissions, and province details. It demonstrates SQL concepts ranging from basic queries to advanced analytical operations.

Tools Used

• MySQL
• MySQL Workbench
• SQL

Database Tables

Patients

Stores patient information such as:

• Patient ID
• First Name
• Last Name
• Gender
• Birth Date
• Height
• Weight
• Allergies
• City
• Province

Doctors

Stores doctor details such as:

• Doctor ID
• First Name
• Last Name
• Specialty

Admissions

Stores patient admission records including:

• Admission Date
• Discharge Date
• Diagnosis
• Doctor ID

Province Names

Stores province information.

SQL Concepts Used

• SELECT Statements
• WHERE Clause
• ORDER BY
• GROUP BY
• HAVING
• Aggregate Functions
• CASE Statements
• JOINS
• UNION
• Subqueries
• UPDATE Statements
• String Functions

Key Features

• Patient record analysis
• Admission tracking system
• Doctor-patient relationship analysis
• Obesity calculation using BMI
• Allergy analysis
• Province-wise patient analysis
• City-wise patient statistics
• Diagnosis-based filtering
• Healthcare data insights

Sample SQL Operations

• Patient filtering queries
• Aggregate analysis using COUNT and SUM
• Joining multiple tables
• Grouping and sorting data
• BMI and obesity analysis
• Diagnosis analysis
• Duplicate admission analysis

Learning Outcome

This project helped improve:

• SQL query writing
• Database management skills
• Analytical thinking
• Real-world healthcare data analysis
• Understanding relational databases

Project Outcome

Successfully developed a healthcare database management project using MySQL and implemented advanced SQL queries to generate meaningful healthcare insights and reports.

Author

Shreenidhi B D