Health Analytics Database Project

I have uploaded three documents for this Database Project. The last two uploaded documents are PowerPoint lecture and other information that maybe needed for the project.

Design Considerations for HIM Related Databases

1. Database design considerations for HIM Professionals are complex and vary widely when considering such factors as database purpose, setting, objectives, targeted audience, and output requirements. Using your past experience in the HIM industry as a guide, please select two topics (a primary and a secondary) that are of professional interest to you that will serve as the basis for developing a database during this semester. Your selection(s) must contain data elements that represent the entire continuum of the patient experience: administrative, clinical, and financial data elements. The instructor will distribute a Database Design Template/Model that will assist you with this process. You can modify the Template/Model to fit your topic.

 

2. When considering design issues for HIM related databases, we must remain mindful of the interrelationships between data elements. In order for an HIM-related database to be useable, linkages must exist between the tables contained within each database. Within your database design, which fields do you plan to use as the key data elements which will enable the various tables in your database to interact with each other?

 

3. When considering issues of database design, we are ultimately concerned with the clinical and regulatory needs of the intended audience. Please specifically identify the intended audience for the database that you intend to design in partial fulfillment of the requirements of this course.

 

The Sample Diabetes Database (in red) on the subsequent page is provided as a guide for this exercise, although your own database design may follow any standard database design convention.

 

 

 

 

Sample Database Design: Diabetes

 

 

Master Patient Index

Field Name Data Type Field Size

PtIdNo AutoNumber Integer

PtLast Text 30

PtFirst Text 30

MRNO Number Double

Gender Text 1

Race Text 10

DOB Date/Time mm/dd/yy;@

 

Encounter

Field Name Data Type Field Size

EncounterId AutoNumber Integer

PtIdNo Number Integer

MRNO Number Double

DOS Date/Time mm/dd/yy;@

Height Number Double

Weight Number Double

Physician Text 35

Date Onset Date/Time mm/dd/yy;@

Insulin Dependent Text 1

A1CScore Number Double

A1CRating Text 10,@

DietCompliance Text 10,@

Neuropathy Text 10,@

Retinopathy Text 10,@

BMI Number Double

BMIRating Text 10,@

 

 

Insurance

Field Name Data Type Field Size

InsuranceId AutoNumber Integer

PtIdNo Number Integer

InsPlanName Text 30

InsPlanNo Text 30

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sample Database Design 1: _________________________

 

Encounter

Field Name Data Type Field Size

EncounterId AutoNumber Integer

PtIdNo Number Integer

 

 

Master Patient Index

Field Name Data Type Field Size

PtIdNo AutoNumber Integer

PtLast Text 30

PtFirst Text 30

MRNO Number Double

Gender Text 1

Race Text 10

DOB Date/Time mm/dd/yy;@

 

 

 

 

 

 

 

 

 

 

 

Insurance

Field Name Data Type Field Size

InsuranceId AutoNumber Integer

PtIdNo Number Integer

InsPlanName Text 30

InsPlanNo Text 30

 

 

 

 

 

 

Sample Database Design 2: _____________________________________

 

Encounter

Field Name Data Type Field Size

EncounterId AutoNumber Integer

PtIdNo Number Integer

 

 

Master Patient Index

Field Name Data Type Field Size

PtIdNo AutoNumber Integer

PtLast Text 30

PtFirst Text 30

MRNO Number Double

Gender Text 1

Race Text 10

DOB Date/Time mm/dd/yy;@

 

 

 

 

 

 

 

 

 

 

 

 

Insurance

Field Name Data Type Field Size

InsuranceId AutoNumber Integer

PtIdNo Number Integer

InsPlanName Text 30

InsPlanNo Text 30

Is this the question you were looking for? If so, place your order here to get started!