Database Design Project: Proposal and DQs
Database Design Project: Proposal and DQs
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:
Statement of the project problem and definition of terms.
Identify your users (personnel/credentials): Who are they? What are their competencies?
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.
Based on your response to #3, articulate the project goals and objectives for the database design and how they affect the data model.
Identify the steps you will take to meet the goals and objectives.
Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any specific assumptions that need to be made?
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.
Topic 1 DQ 1
Consider the following scenario: You are in a hospital setting that uses an enterprise EHR system with multiple interfaces to other health information platforms. What types of data would be kept in each system and what steps would be needed to allow for analytics to be performed across multiple disparate platforms?
Topic 1 DQ 2
Compare traditional paper health records to electronic records. What can one do that the other cannot? Some of the formats of electronic data include spreadsheets and databases. What are some of the trade-offs between using a spreadsheet versus a database to record, analyze, and retrieve data in a health care setting?
