SQL database

I designed and implemented a medical prescription database using SQL. The project simulates a healthcare system where doctors prescribe medications to patients.

Key features of the project:

Created relational tables for Doctors, Patients, Medications, and Prescriptions.

Established relationships between entities using primary and foreign keys.

Wrote SQL queries to:

Retrieve prescriptions with doctor, patient, and medication details.

Find all prescriptions issued by a specific doctor.

List medications prescribed to a particular patient.

Generate detailed reports combining multiple tables with JOIN operations.

Ensured query accuracy and efficiency for healthcare data management.

Tools Used: SQL Server / MySQL (can be adapted).