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