This is a MySQL project that focuses on creating a centralized database that can be accessed by doctors and their associates all across. The aim of the project is to be able to book and manage appointments for the patient, view appointment history, view invoice and prescription of the patients. View patinet history. There are two different roles. Both the roles have different screen after login and the different activity areas.
- Admin will be able to monitor all information about the doctor, patient and appointments.
- Doctor will be able to view and manage patient appointment history, cancel or book any appointment in the availabe slots which are modified by a trigger after each insert in the table.
The ERD of the project is as follows:
