You have a small company for developing a system for the medical organization. Recently you have been offered a project from the government to develop an
application for a government healthcare center to keep track of rural people's health
information and their health insurance including patient information, Doctor
information, and information regarding patient visits to their corresponding doctor and
prescription drugs prescribed to patients.
Information like patient name, address, age, phone, email, etc. are required and each
patient's primary care doctor is their insurance ID number and insurance company
name. The system needs information on each doctor such as their specialty and what
hospitals they are affiliated with as well as their address, phone, degree, etc. Regarding
the hospitals themselves, the system will be designed where they are located and how to
contact them.
The prescription which is prescribed by the doctor requires to be traced in the particular
database at the time the patient claim for insurance. So, the system needs to know every
drug's name, purpose, and possible side effects.
Based on the business scenario stated above you will identify the database needs, and
then create a front-end interface to access the information.
For understanding a medical health care system, read articles and check the internet to
understand the challenges of tracking the information.
Implement all the functionality using PHP for designing the front-end interface and
MySql for the database.
a. Make a list of business needs, rules, and assumptions based on the above scenario and
research from the internet.

b. Build a database for supporting each functionality mentioned in the above scenario.
c. Build a front-end interface to interact with the functionality of the database.