Hospital SQL Database Project

The Hospital SQL Database Project was created to demonstrate the management of hospital data through SQL. The project focuses on handling patient records, doctor information, appointments, medical records, and billing details within a hospital's database.

The database structure includes the following main entities:

• Patients
• Doctors
• Departments
• Appointments
• Medical Records
• Billing

SQL & Database Design: The primary goal was to design and implement a relational database to store and manage hospital information. The main tables I created were:

• Patients: Stores patient info like name, age, gender, contact, and address.
• Doctors: Stores doctor name, specialty, department, and contact info.
• Departments: Lists various hospital departments like Cardiology, Neurology, etc.
• Appointments: Links patients and doctors with date and time.
• Medical Records: Contains diagnosis and treatment history for each patient.
• Billing: Stores billing details like amount, payment method, and date.

Sample SQL Queries:

For instance, here’s how the Patients table was created:

CREATE TABLE Patients (
    PatientID INT PRIMARY KEY,
    Name VARCHAR(100),
    Age INT,
    Gender VARCHAR(10),
    Contact VARCHAR(15),
    Address TEXT
);
    

For joining tables, here’s a query that links patient and doctor appointments:

SELECT A.AppointmentID, P.Name AS Patient, D.Name AS Doctor, A.AppointmentDate
FROM Appointments A
JOIN Patients P ON A.PatientID = P.PatientID
JOIN Doctors D ON A.DoctorID = D.DoctorID;
    

Challenges: One of the key challenges I faced was understanding the importance of Foreign Keys and how they maintain relationships between the tables. Another challenge was normalizing the data to ensure that redundancy and inconsistencies were minimized.

Conclusion: This project not only deepened my understanding of SQL but also helped me see how SQL is used to handle real-world data, especially in critical fields like healthcare. I would highly recommend anyone learning SQL to explore projects like this, as they give a great hands-on experience with relational databases.