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.
Doctors
DoctorD
FullName
Specialty
Email
Medical Records
RecordID
Prescriptions
PatientID
PrescriptionID
PatientID
DoctorID
DoctorID
AppointmentID
RecordID
Diagnosis
Medicine
Treatment
Phone
Experience Years
Notes
Appointments
AppointmentID
PatientID
DoctorD
AppointmentDate
Status
Notes
CreatedAt
Zoom
- FUO
+ 100%
RecordDate
Patients
"
PatientID
FirstName
LastName
Billina
BillID
PatientID
AppointmentID
TotalAmount
PaidAmount
PaymentStatus
BillDate
DateOfBirth
Gender
Email
Phone
Address
BloodType
Dosage
Instructions
PrescriptionDate
Close
