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).
