Kizspy.me
+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the .sql file which has the following
database diagram. Please, run the provided script to create tables and insert data into your database.
Zoom
Doctors
DoctoriD
FullName
Specialty
Email
Phone
Experience Years
Appointments
AppointmentID
MedicalRecords
RecordID
Prescriptions
PrescriptionID
PatientID
PatientID
DoctorID
Doctor D
AppointmentID
RecordID
Diagnosis
Medicine
Treatment
Notes
RecordDate
Dosage
Instructions
PrescriptionDate
Patients
PatientID
FirstName
PatientID
DoctorID
LastName
AppointmentDate
DateOfBirth
Billing
Status
Gender
BilliD
Notes
Email
PatientID
CreatedAt
Phone
AppointmentID
Address
TotalAmount
BloodType
PaidAmount
PaymentStatus
BillDate
+ 100%
Close
