From the 2nd question, you should use the database provided in the .sql file which has the following
✓ Kizspy.me Fatama tee 2nd q. Please, run the provided script to create tables and insert data into your database.
Zoom
Doctors
DoctorD
FullName
Specialty
Email
Phone
Experience Years
Medical Records
RecordID
Prescriptions
PrescriptionID
PatientID
PatientID
DoctoriD
DoctoriD
AppointmentID
RecordID
Diagnosis
Medicine
Treatment
Notes
RecordDate
Dosage
Instructions
PrescriptionDate
Appointments
AppointmentID
PatientiD
DoctorD
AppointmentDate
Billina
Status
BillD
Notes
CreatedAt
+100%
Patients
PatientID
FirstName
LastName
DateOfBirth
Gender
Email
PatientID
Phone
AppointmentID
Address
TotalAmount
BloodType
PaidAmount
PaymentStatus
BillDate
Close
