-
Execute Auditing.sql
-
DBStructure.sql
-
Permissions.sql
-
Populate.sql
-
DataProtection.sql
-
Test.sql
- patient.
- Ensure that the patient can view their details.
- Ensure that the patient can update their details (passport number, phone and payment card details).
- Ensure that the patient can check their prescribed medication.
- Ensure that the patient cannot access other patients' details or medication information.
- nurses.
- Ensure that the nurse can view their details.
- Ensure that the nurse can update their details (passport number, telephone).
- Ensure that the nurse can check the patient's medication details.
- Ensure that the nurse can view and update the patient's personal details.
- doctors.
- Ensure that the doctor can view your details.
- Ensure that the doctor can update his/her details (passport number, telephone).
- Ensure that the doctor can add new medication details to the patient.
- Ensure that the doctor can update or remove medication details that he/she has added.
- Ensure that the doctor cannot update or remove medication details added by another doctor.
- Ensure that the doctor can check the patient's personal details.