The purpose of this assignment is to provide learners a basic understanding for identifying a database project proposal for collecting data and for designing and developing a small database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products
The purpose of this assignment is to provide learners a basic understanding for identifying a database project proposal for collecting data and for designing and developing a small database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products and
utilization.
There are three parts to the database project proposal. The initial step involves identifying an idea for a database and describing its purpose. The second
part allows you to design the database components. The third part requires you to present the database proposal to stakeholders. Feedback from the
instructor at every stage will help you make improvements in the database project.
To complete Part 1 of the Database Project Proposal assignment, create a 500-750-word proposal outlining the following elements:
State the project problem and definition of terms.
Identify database users (personnel/credentials): Who are they? What are their competencies and background?
Discuss the types of data that users will collect for the proposed database and describe at least three reports that will be generated for analysis. Explain their
use and who will use the reports?
Describe the project goals and clear measurable objectives for the database. 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?
Discuss data communications protocols that could be used in your database project. Refer to the “Blockchain Personal Health Records: Systematic Review”
article, provided in the topic Resources.
Conclude with the value of the project with emphasis on feasibility and the benefit of the expected results.
Prepare this according to the guidelines found in the APA Style Guide
The purpose of this assignment is to provide you with a basic understanding for identifying a database project proposal and then designing and developing a small database that can be used to compile and report clinical data related to either quality measures or pharmaceutical products. The first step is to identify the need for such a database. After that, you will design the tables, fields, and relationships needed to store the data. Finally, you will develop the necessary code to populate and query the database.
This assignment is divided into three parts. In Part A, you will identify a potential database project proposal. In Part B, you will design the tables, fields, and relationships needed to store the data. And in Part C, you will develop the necessary code to populate and query the database.
Part A: Identifying a Database Project Proposal
The first step is to identify a potential database project proposal. There are many sources of information that can be used to identify such a proposal. One possibility is to search the Internet for organizations that collect data related to quality measures or pharmaceutical products. Another possibility is to contact your local hospital or clinics and inquire about their needs for collecting and reporting clinical data.
Once you have identified a potential database project proposal, the next step is to gather information about the organization and the data they collect. You will need to determine the following:
-The name and contact information for the organization
-The nature of the data they collect (quality measures or pharmaceutical products)
-The format of the data (electronic or paper)
-The frequency with which they collect data (daily, weekly, monthly, etc.)
-The amount of data they collect (number of quality measures or pharmaceutical products)
Part B: Designing Tables, Fields, and Relationships
After you have gathered information about the organization and the data they collect, you will need to design the tables, fields, and relationships needed to store the data. There are many different ways to design a database, but for this assignment you will need to create the following:
-One table for storing quality measure data
-One table for storing pharmaceutical product data
-One relationship between the two tables
The tables you create should have the following fields:
-A unique identifier field (ID) for each record
-A field for the quality measure or pharmaceutical product name
-A field for the date on which the data was collected
-A field for the source of the data (hospital, clinic, etc.)
-A field for the value of the quality measure or pharmaceutical product
Part C: Developing Code to Populate and Query the Database
In this final part of the assignment, you will develop the necessary code to populate and query the database. The code you develop should be able to do the following:
-Insert new records into the database
-Update existing records in the database
-Delete records from the database
-Retrieve data from the database based on various criteria (quality measure name, date, source, etc.)
Once you have developed the code to populate and query the database, you should test it to ensure it is working properly. You can do this by inserting some sample data into the database and then querying the database to see if the data can be retrieved correctly.