From the 2nd question, you should use the database provided in the .sql file which has the following
✓ Kizspy.me Fatama the 2nd qu. Please, run the provided script to create tables and insert data into your database.
Zoom
Doctors
Doctor D
FullName
Specialty
Email
Phone
ExperienceYears
Appointments
AppointmentID
PatientID
DoctorID
AppointmentDate
Billing
Status
BilliD
Notes
CreatedAt
+ 100%
MedicalRecords
RecordID
Prescriptions
PrescriptionID
PatientID
PatientID
DoctorID
DoctorID
AppointmentID
RecordID
Diagnosis
Medicine
Treatment
Notes
RecordDate
Dosage
Instructions
PrescriptionDate
Patients
PatientID
FirstName
LastName
PatientID
AppointmentID
TotalAmount
DateOfBirth
Gender
Email
Phone
Address
PaidAmount
PaymentStatus
BillDate
BloodType
Close
