Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are tasked with developing a comprehensive program code ( php ) for a Clinic Patient Management System based on the provided information using PHP

You are tasked with developing a comprehensive program code (php) for a Clinic Patient Management
System based on the provided information using PHP and CSS. ASSIGNMENT
Lens:
Lens Price:
Frame:
Frame code:
Frame Price:
Amount:
Discount:
TOTAL
Mode of payment:
Optometrist:
REPLACEMENTS:
Start-up Page
First of all, the system needs to have a start-up page for the clinic staff. This page consists of:
\table[[Functions,Descriptions],[Clinic Logo,\table[[This is the logo of the clinic which needs to],[design it based on your creativity.]]],[Welcoming Text,\table[[This is the text to welcome all the users into the],[system.]]],[Register Button,\table[[Button for new users to register an account in this],[system]]],[Login Button,\table[[Button for the existing users to login into the],[system before using it.]]]]
Patient Profile
\table[[Input Details,Descriptions],[Patient's Name,\table[[Name of the patient that want to register a new],[account in this system]]],[Date Examined,\table[[Allowing the attendant to insert a date of],[examination of the patient]]],[Age,\table[[The attendant needs to input the phone number],[into the system.]]],[Address,\table[[Allow the librarian to insert a chosen username],[that consist of strings and numbers.]]],[Birthdate,\table[[Allowing the attendant to insert the patient's date],[of birth]]],[Contact,\table[[Allowing the attendant to insert the patient's],[contact information]]],[Patient's Complain - Concerns,\table[[Allowing the attendant to insert the patients],[complains or concerns]]]]
Page 3 of 7 ASSIGNMENT
Health History
Allowing the attendant to insert the patient's
health history
Rx Form
Modified/Final Rx
PD Form
PD
Contact Lens Conversion
Diagnosis and Remarks Form
Each form must be able to add and retrieve transaction information. 1.1 Login Page
For the login page, the existing users (the attendants) need to input all the information details:
\table[[Input Details,Descriptions],[Username,Insert the existing username],[Password,Insert the existing password],[Message Box,\table[[Display a message for validation if the user],[entered the wrong username or password]]]]
2.1 Patient Profile Page
When users click on the patient menu in the menu list page, it will show this page that offers variety of functions.
This page consists of all the below functions:
\table[[Functions,Descriptions],[Search/Retrieve,\table[[With this function, users can look for a patient's],[details by entering parameters like name, patient],[ID, or medical record number (users can select],[any of these). The comprehensive patient data,],[including patient ID, date of birth, name,],[contact details, attending physician, and medical],[history, will all be shown on one page.]]],[Add,\table[[This capability enables users to input new details],[for a patient into the database.]]],[Update,\table[[This capability enables users to update new],[details for a patient into the database.]]],[Delete,\table[[This capability enables users to delete details for],[a patient from the database.]]],[Return,To exit this page and return to the menu list page]]
3.0 Database
For the database of this system, it consists of all the below tables:
\table[[Functions,Descriptions],[User,\table[[This table stores all the data for the registered],[users in the system (date stored: staff name, staff],[id, phone number, username and password)]]],[Patients,\table[["This table stores all the information and details],[about the patient that are provided in the medical],[records (data stored: patient ID, date of birth,]]]]
Page 5 of 73.0 Database
For the database of this system, it consists of all the below tables:
ASSIGNMENT
The newly established Haven Eye Clinic, supported by government funding, has commenced its
services. Accessible to the public, the clinic is staffed by three (3) healthcare professionals. In light
of this, there is a crucial need for a Clinic Patient Management System to streamline the clinic's
operations. The system should enable eye care providers to manage patient information efficiently,
facilitating appointment scheduling, tracking medical records, and managing the examinations
processes. The detailed system requirements are outlined below.
Patients Name:
Date Examined:
Age:
Address:
Contact number:
Patient's Complaint/concerns:
Healthy History:
Px
Modified/Final Rx
PD:
Contact lens comversion:
Diagnosis:
Remarks:
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro SQL Server Administration

Authors: Peter Carter

1st Edition

1484207106, 9781484207109

Students also viewed these Databases questions

Question

Why is failing to reject ????0 often an unreliable decision?

Answered: 1 week ago

Question

Identify traditional external recruitment methods.

Answered: 1 week ago

Question

Describe alternatives to recruitment.

Answered: 1 week ago