Capital Family Clinic Appointment Management System

Home

A for-profit medical clinic business in the United States needs a website with a database backend to track its patients, clinic locations, tests, and appointments. The business currently relies on Excel spreadsheets to manage its data, but with anticipated growth, a more efficient system is needed. The business operates 3 locations but has plans to open 7 more clinics by the end of the year. The main clinic sees an average of 30-40 patients each day. The primary purpose of the clinics is to offer basic medical tests, rather than performing advanced surgery or imaging procedures. Each location offers the same easy point-of-care testing procedures to allow patients to choose their preferred clinic. The management team will use this new software system to determine information such as how busy each clinic is and which tests are most requested.

This database currently stores the following information:

• Clinics: Represents the location of a clinic where appointments take place.
• Patients: Represents a patient who may make an appointment at a clinic.
• Appointments: Represents an appointment for a patient.
• Statuses: Represents the appointment status. Each status (Scheduled, Walk In, No Show, Cancelled, Complete) is represented by a specific statusId.
• Results: Represents the results of a test. Each result (positive, negative, or invalid) is represented by a specific testResultId.
• Tests: Represents a test that a patient may take at the clinic.
• Scheduled Tests: Represents the M:N relationship between appointments and tests. Each scheduled test is also associated with one test result.