Project Five: Wellness Clinic-Medical Group General Description The Wellness Cli
ID: 3664863 • Letter: P
Question
Project Five: Wellness Clinic-Medical Group General Description The Wellness Clinic is a facility providing medical care in a rural area of the country. Its professional staff consists of five medical doctors (physi- cians), two nurse-practitioners who provide non-acute care and can pre- scribe medication, two registered nurses, two midwives who provide Student Projects: Introduction to Student Projects 61 pre-natal care and supervise delivery except in cases with complications, a pharmacist, and a medical technician. The non-professional staff mem- bers include an office administrator, a receptionist, and a bookkeeper who works part-time. The clinic serves several thousand patients, each of whom may visit the clinic any number of times per year, both for preven- tative care such as checkups or immunizations, and for treatment of ill- ness. Its facilities consist of a waiting room with a reception desk, an administrative office, a nurses' station, 10 examining rooms with adjoin ing consultation rooms, a small operating room, a birthing room, a recov ery room, a pharmacy, and a small laboratory. BasicOperations The clinic has regular hours of operation weekdays, Saturday mornings, and two evenings per week. Normally two physicians or one physician and one nurse practitioner, one registered nurse, and one midwife are in the clinic during regular hours. In addition, the professional staff members rotate responsibility for covering emergency calls 24 hours per day, seven days a week. At the end of each day, the administrator or receptionist sets up call forwarding so that emergency calls are automatically directed to the telephone number of the person providing emergency coverage. When the clinic opens in the morning, the call forwarding is halted. Two of the physicians are surgeons who perform routine surgery not requiring general anesthesia at the clinic one morning a week, assisted by a nurse. Others have specialties in pediatrics and internal medicine. However, all of the physicians can provide general and acute care for any of the patients. Patients who require major surgery or other hospital care must go to a hospital located outside the immediate area served by the clinic. The clinic staff members do not normally visit their patients who are in the hospital, instead leaving their care to the hospital staff with whom the clinic com municates during the hospitalization. However, the clinic provides both pre- and post-hospital care for the patients. Hours of operation are divided into scheduled appointments and unsched uled hours that are open for walk-ins. Patients usually schedule checkups and immunizations well in advance. Patients suffering from chronic or acute illness can usually schedule appointments promptly, or they may come in during the unscheduled hours. The administrator is responsible for setting up all schedules, both for the staff and for patients, and for keeping records updated. Prior to the beginning of each month, the administrator 2Explanation / Answer
1) CREATE TABLE `weeklycoverageschedule` (
`empId` int(5) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`phone` text NOT NULL,
`shiftStart` time NOT NULL,
`shiftStop` time NOT NULL,
`isProfessional` tinyint(1) NOT NULL,
`coverEmergency` tinyint(1) NOT NULL,
PRIMARY KEY (`empId`)
)
2)
CREATE TABLE `dailymasterschedule` (
`practionerId` int(11) NOT NULL AUTO_INCREMENT,
`dayOfTheWeek` varchar(10) NOT NULL,
`appointementStartTime` time NOT NULL,
`appointementStopTime` time NOT NULL,
`patientId` int(11) NOT NULL,
PRIMARY KEY (`practionerId`)
)
CREATE TABLE `individualpractionerdailyschedule` (
`practionerId` int(11) NOT NULL AUTO_INCREMENT,
`patientName` varchar(25) NOT NULL,
`reasonForVisit` text NOT NULL,
PRIMARY KEY (`practionerId`)
)
3) CREATE TABLE `insuranceform` (
`clinicName` varchar(25) NOT NULL,
`address` text NOT NULL,
`phone` text NOT NULL,
`insuranceProfessionalName` varchar(25) NOT NULL,
`taxId` varchar(10) NOT NULL,
`insuranceId` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`insuranceId`)
)
4) CREATE TABLE `patientmonthlystatement` (
`patientId` int(11) NOT NULL,
`servicesProvided` text NOT NULL,
`paymentsReceived` int(11) NOT NULL,
`balanceDue` int(11) NOT NULL
)
CREATE TABLE `dailymasterschedule` (
`practionerId` int(11) NOT NULL AUTO_INCREMENT,
`dayOfTheWeek` varchar(10) NOT NULL,
`appointementStartTime` time NOT NULL,
`appointementStopTime` time NOT NULL,
`patientId` int(11) NOT NULL,
PRIMARY KEY (`practionerId`)
)
CREATE TABLE `individualpractionerdailyschedule` (
`practionerId` int(11) NOT NULL AUTO_INCREMENT,
`patientName` varchar(25) NOT NULL,
`reasonForVisit` text NOT NULL,
PRIMARY KEY (`practionerId`)
)
3) CREATE TABLE `insuranceform` (
`clinicName` varchar(25) NOT NULL,
`address` text NOT NULL,
`phone` text NOT NULL,
`insuranceProfessionalName` varchar(25) NOT NULL,
`taxId` varchar(10) NOT NULL,
`insuranceId` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`insuranceId`)
)
4) CREATE TABLE `patientmonthlystatement` (
`patientId` int(11) NOT NULL,
`servicesProvided` text NOT NULL,
`paymentsReceived` int(11) NOT NULL,
`balanceDue` int(11) NOT NULL
)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.