Project: Create a Software Application Module for Patient Data and a Wellness History

Synopsis: A physicians group has decided to update their technology to something more modern and efficient. The segment of the task that requires your attention is in regards to the Patient Care System. This system will need to collect information and store it into a database, as well as record wellness evaluation data that is collected on each patient.

Description: A local physicians group, called LPG, is restructuring its internal technology processes. LPG consists of approximately 25 physicians, lab and x-ray technicians, nurses and assistants, as well as front office staff. In the community in which LPG operates, they serve approximately 3,000 patients, delivering services such as emergency medical treatment, wellness checkups, disease management, as well as many other medical offerings.

The company has chosen to create a new database system for patient record storage, as well as a new user interface for keeping track of patients and their medical histories.

You work as an application software developer for an international corporation that has received the contract to create the system, IBN. You are the primary developer and business interface between IBN and LPG.

IBNs specialists have already determined which software language and database that the application will be created with. In addition, they have determined the first two modules that will be implemented: Basic Patient Data and Profile, and Wellness Checkup Profile.

Basic Patient Data and Profile: This comprises the basic information collected regarding a patient. It will encompass common information such as name, address, phone number, email address, primary care physician, health insurance provider/group number/member number, and so on. It will also contain profile information that will create a quick view of data collected from the wellness checkup, such as average bpm, diastolic and systolic blood pressure, as well as most recent information such as weight, height, blood pressure, current medications, and so on.

Wellness Checkup Profile: Every six months and/or when visiting due to illness, patients receive a screening that collects basic information: Date and time of checkup, diastolic and systolic blood pressure, heart rate, weight, height, current medicines, and so forth. This is a new record for each visit that will be used to aggregate historical patient data. Each record is editable, but should not have its information overwritten when the patient next visits, but instead receive a new record for each visitation date.

Deliverables:

You will inform LPG as to the database and software language chosen by IBN to create their new application, in written form. You must detail the reasons that this particular database and language were chosen, without being overly technical to the LPG Technology Committee that you will be interfacing with.

A single Word document detailing these requirements is sufficient.

You must develop the database for the first phase of the project, providing the data structure for Basic Patient Data and Profile, and the Wellness Checkup Profile. Tables should follow standard entity-relationship industry practices.

Submit an entity-relationship diagram detailing data structure

Provide a backup file of the database with your implemented data structure

You must develop and deliver the operational front-end that allows for the entry of the data into the first phase screens, in the language that you choose. It must be operational and connect to the database that you created in Deliverable #2.

Provide all code and files in zip archive, required to run the project

You must provide the above documentation from Deliverable #1, with installation instructions for implementing your First Phase deliverables for items #2 and #3.

Provide installation instructions to implement the system. This can be a single Word