The Database Design Project consists of several assignments that are due in various topics throughout the course. For this project, students will design and develop a database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products and utilization.
The Database Design Project consists of several assignments that are due in various topics throughout the course. For this project, students will design and develop a database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products and utilization. The proposal is the initial step of this assignment.
Create a 500-750-word proposal outlining the following:
1. Statement of the project problem and definition of terms.
2. Identify your users (personnel/credentials): Who are they? What are their competencies?
3. Discuss the information data users need to compile for the proposed system and the types of reports the proposed system should be able to generate and why.
4. Based on your response to #3, articulate the project goals and objectives for the database design and how they affect the data model.
5. Identify the steps you will take to meet the goals and objectives.
6. Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any specific assumptions that need to be made?
7. Conclude with the value of the project with emphasis on feasibility, necessity, usefulness, and the benefit of the expected results.
This is an ongoing project and the feedback from the instructor at every stage will help you in improving your final project. Be sure to consult with your instructor throughout the course and incorporate suggestions and recommendations in your project.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.
HIM650 Health Care Data Management
Week 2 Assignment
Database Schema
Design a database schema for the proposed Database Design Proposal in Module 1.
Identify and list all relevant entities and their relationships:
1) Select no less than five entities.
2) Provide a diagram.
3) Map this to a database schema.
4) Provide a data dictionary for all entity attributes.
Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions.
Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field.
APA format is not required, but solid academic writing is expected.
This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.
This assignment will be utilized again in Topic 4 and 5. Prior to Topic 4, review any feedback provided to you by the instructor.
You are not required to submit this assignment to LopesWrite.
HIM650 Health Care Data Management
Week 3 Assignment
Risk Incidence Occurrence Solution
In reference to your Database Design Proposal from topic 1, consider a situation where you want to track, and ultimately identify performance variances (quality measures) or the occurrence of at-risk incidents (pharmaceutical) within the environment you selected.
Write a 500-750 word proposal for an incident solution from the perspective of the Health Information Manager. Include the following criteria in your proposal:
Identify and select an incident in which you are interested.
1. For your risk incidence solution, discuss the proposed solution and specification of the requirements.
2. Describe the database design and/or modifications to existing databases
3. Describe the required resources to develop data model, including hosting considerations.
4. Explain the breakdown of responsibilities among staff to collect, analyze, and disseminate the information.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.
HIM650 Health Care Data Management
Week 4 Assignment
SQL Queries
For this assignment you will create SQL queries use the following database schema:
1. Patient—PatientID, Name, DOB
2. Doctor—DoctorID, Name, MedLicenseNumber, Phone
3. Medication—MedicationID, BrandName, GenericName
4. Prescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationID
Specify the SQL queries to retrieve:
1. A list of all doctors.
2. The number of patients who were born before 01/01/1994.
3. The patient information along with the ID of any prescribing doctor for each patient.
4. The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.
5. The most prescribed generic medication name.
APA style is not required, but solid academic writing is expected.
You are not required to submit this assignment to LopesWrite.
HIM650 Health Care Data Management
Week 4 Assignment
Database Schema-SQL Statements
1) Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).
2) Modify the database by adding an additional column (“Deleted_Date”) to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?
APA format is not required, but solid academic writing is expected.
This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.
You are not required to submit this assignment to LopesWrite.
HIM650 Health Care Data Management
Week 6 Assignment
Health Data Reporting
For this assignment, you will write 500-700-word paper discussing the legal duty to report health data to a state or federal public health agency. Choose two examples where a legal duty exists to report health data to a state or federal public health agency. These examples can be items recently reported in the news.
Include the following items in your paper:
1. Summarize the examples you’ve chosen. Describe why these examples require mandatory reporting.
2. Discuss how the information is gathered and submitted to the authorities.
3. Propose ways of improving the status quo and provide reasons why this has not yet been accomplished.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
HIM650 Health Care Data Management
Week 7 Assignment
Database Design Proposal: Product
In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database.
The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS). Refer to “Supplement: SQL Examples for SQLite Database,” for the link to the SQLite Database download and examples.
The working prototype should include the following:
1. Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design and how it would be used to support data warehousing, reporting and mining
2. Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
