Design and Develop a Database that can be used to Compile and Report "Clinical Data"



Part - 1

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.

Prepare this assignment according to the guidelines found in the APA Style Guide .This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.


Note: Please consider a health care problem as an example , how do you resolve the problem with database design and write a proposal to client.


Part -2

Design a database schema for the proposed Database Design Proposal in Part 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.


Part - 3

In reference to your Database Design Proposal from part 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:


1. Identify and select an incident in which you are interested.

2. For your risk incidence solution, discuss the proposed solution and specification of the requirements.

3. Describe the database design and/or modifications to existing databases

4. Describe the required resources to develop data model, including hosting considerations.

5. 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.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.


part - 4

1) Based on part 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.


part - 5

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).

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




If you like Codersarts blog and looking for Assignment help,Project help, Programming tutors help and suggestion  you can send mail at contact@codersarts.com.

Please write your suggestion in comment section below if you find anything incorrect in this blog post

Contact Us

Tel: (+91) 0120  4118730  

Time :   10 : 00  AM -  08 : 00 PM IST 

Registered address: G-69, Sector 63, 

 Noida - 201301, India

We Provide Services Across The different countries

USA    Australia   Canada   UK    UAE    Singapore   New Zealand    Malasia   India   Ireland   Germany

CodersArts is a Product by Sofstack Technology Solutions Pvt. Ltd.

  • CodersArts | Linkedin
  • Instagram