HIF 550: Clinical Database Management

Course Description

Addresses healthcare database theory, database design and query of health databases. Utilize technology for data collection, storage, analysis, and reporting of information by applying knowledge of database architecture and design to meet organizational needs. This course covers basic to intermediate knowledge of the concept, the design, and the implementation of database applications in healthcare. Students will study tools, data models, relational systems, and database administration. 

Prerequisites

  • None

Associated Program Learning Outcomes

Upon successful completion of the course, the student will be able to:

  • #1. Apply healthcare informatics and technology concepts and skills to case studies and real-world situations
  • #2. Calculate and assess health data and statistical data for decision making in the healthcare environment.
  • #3. Develop system design and software initiatives for healthcare organizations.
  • #4. Compile, conduct and create new information based the use of technology and datasets through data analytics.

Student Learning Outcomes (SLOs)

Upon successful completion of the course, the student will be able to:

  1. Identify common database terminology to appropriate definition.
  2. Describe the database management lifecycle and the key phases involved in each step.
  3. Critique sample entity-relationship diagram and recommend changes that could be made to improve database management.
  4. Conduct the correct calculations on healthcare data for formulas that are used in healthcare decision making.
  5. Investigate a real-life database issue (identified by student group) by interviewing client and generate a team report for each phase of the database development lifecycle (semester long project).
  6. Generate a final team report of identified database issues and proposed solution and deliver to client/professor.
  7. Design and present the group projects’ final presentation to the class and client(s).
  8. Apply basic understanding of SQL to answer real-life case study examples.
  9. Critique multiple healthcare system infrastructures and examine pros and cons of differing structures.
  10. Examine data quality issues in healthcare and pinpoint some of the greatest challenges faced by the industry.

 

Course Activities and Grading

AssignmentsPointsWeight

Discussions (25 Pts Each, Weeks 1, 3, 5 & 7)

100

10%

Assignments (25 Pts Each, Weeks 1, 3, 5 & 7)

100

10%

Team Phase 1-4 Report (100 Pts Each, Weeks 2, 4, 6 & 8)

400

40%

Team Assessment (40 Pts Each, Weeks 2, 4 & 6)

120

12%

Final Team Project Presentation (Week 8)

280

28%

Total

1,000

100%

Required Textbook

Available through Charter Oak State College's Book Bundle

  • Hoffer, Jeffery A., Ramesh, V., Topi, Heikki. Modern Database Management. 13th ed. Pearson Publishing, 2019. ISBN-13: 978-0-13-477365-0

Additional Resources

 

Course Schedule

Week

PLOs

SLOs

Readings and Exercises

Assignments

1

1

1,2

Topics: Introduction to Clinical Database Management and Team Project Overview

  • Readings:
    • PowerPoint presentation, Week #1 lecture
  • Review Getting Started information
  • Review course syllabus
  • Read assigned chapters
  • Review the lecture material
  • Introduce yourself to class and team members for group project in discussion forum
  • Complete week #1 assignment

2

3

1,5

Topics: NDCs, CDT, ICF, and ABC Codes

  • Readings:
    • Modern Database Management, Chapter 1
    • PowerPoint presentation, Week #2 lecture
  • Read assigned chapters
  • Review the lecture material
  • Begin work on course project and submit phase 1 team report by end of week #2
  • Complete group project phase 1 team member participation and self-assessment

3

1,4

1,3

Topics: Database Analysis and Logical Design

  • Readings:
    • Modern Database Management Chapter 2-4
    • PowerPoint presentation, Week #3 lecture

 

  • Read assigned chapters
  • Review the lecture material
  • Participate in discussion
  • Complete week #3 assignment

4

1,3

1,5,8

Topic: Database Implementation and Use

  • Readings:
    • Modern Database Management Chapter 5 & 6
    • PowerPoint presentation, Week #4 lecture

 

  • Read assigned chapters
  • Review the lecture material
  • Submit phase 2 team report by end of week #4
  • Complete group project phase 2 team member participation and self-assessment 

5

1,4

1,8

Topics: Database Implementation and Use, Continued

  • Readings:
    • Modern Database Management Chapter 7 & 8
    • PowerPoint presentation, Week #5 lecture
  • Read assigned chapters
  • Review the lecture material
  • Participate in discussion
  • Complete week #5 assignment

6

1,3

1,5,9,10

Topic: Advanced Database Topics

  • Readings:
    • Modern Database Management Chapter 9-12
    • PowerPoint presentation, Week #6 lecture
  • Read assigned chapters
  • Review the lecture material
  • Submit phase 3 team report by end of week #6
  • Complete group project phase 3 team member participation and self-assessment 

7

 1,2

1,4

Topics: Finding and Using Health Statistics

  • Readings:
    • Linked Article
    • PowerPoint presentation, Week #7 lecture

 

  • Read assigned chapters
  • Review the lecture material
  • Participate in discussion
  • Complete week #7 assignment

8

1,2,3,4

6,7

Topics: Present Final Team Report to Class, Instructor and Project Stakeholder

  • Readings:
    • None
  • Share final project with class, instructor and invite project stakeholder to presentation
  • Submit team project final written report to instructor

COSC Accessibility Statement

Charter Oak State College encourages students with disabilities, including non-visible disabilities such as chronic diseases, learning disabilities, head injury, attention deficit/hyperactive disorder, or psychiatric disabilities, to discuss appropriate accommodations with the Office of Accessibility Services at OAS@charteroak.edu.

COSC Policies, Course Policies, Academic Support Services and Resources

Students are responsible for knowing all Charter Oak State College (COSC) institutional policies, course-specific policies, procedures, and available academic support services and resources. Please see COSC Policies for COSC institutional policies, and see also specific policies related to this course. See COSC Resources for information regarding available academic support services and resources.