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!