Design a small application using Code Igniter MVC Framework with the following functionalities [closed]

Design a database with the following tables:

1. User
2. Front desk
3. Patients
4. Doctor
5. Nurse
   (You can give any columns as you like)
   You would have to implement role management.
   Design a small application using Code Igniter MVC Framework with the following functionalities.
6. User wise login (doctor login, nurse login and front desk login)
7. Front desk can add patients.
8. After adding patients, front desk will assign patient to nurse.
9. After nurse is logged in, nurse will see the patient and will assign it to the doctor.
10. After doctor is logged in, patient will be visible to the doctor.

I m stuck at the second query can anyone please help me?