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:
- Identify common database terminology to appropriate definition.
- Describe the database management lifecycle and the key phases involved in each step.
- Critique sample entity-relationship diagram and recommend changes that could be made to improve database management.
- Conduct the correct calculations on healthcare data for formulas that are used in healthcare decision making.
- 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).
- Generate a final team report of identified database issues and proposed solution and deliver to client/professor.
- Design and present the group projects’ final presentation to the class and client(s).
- Apply basic understanding of SQL to answer real-life case study examples.
- Critique multiple healthcare system infrastructures and examine pros and cons of differing structures.
- Examine data quality issues in healthcare and pinpoint some of the greatest challenges faced by the industry.
Course Activities and Grading
| Assignments | Points | Weight |
|---|---|---|
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 online bookstore
- Hoffer, Jeffery A., Ramesh, V., Topi, Heikki. Modern Database Management. 13th ed. Pearson Publishing, 2019. ISBN-13: 978-0-13-477365-0
Additional Resources
- Health Statistics course from the National Library of Medicine
- Other content provided by the faculty
Course Schedule
Week | PLOs | SLOs | Readings and Exercises | Assignments |
1 | 1 | 1,2 | Topics: Introduction to Clinical Database Management and Team Project Overview
|
|
2 | 3 | 1,5 | Topics: NDCs, CDT, ICF, and ABC Codes
|
|
3 | 1,4 | 1,3 | Topics: Database Analysis and Logical Design
|
|
4 | 1,3 | 1,5,8 | Topic: Database Implementation and Use
|
|
5 | 1,4 | 1,8 | Topics: Database Implementation and Use, Continued
|
|
6 | 1,3 | 1,5,9,10 | Topic: Advanced Database Topics
|
|
7 | 1,2 | 1,4 | Topics: Finding and Using Health Statistics
|
|
8 | 1,2,3,4 | 6,7 | Topics: Present Final Team Report to Class, Instructor and Project Stakeholder
|
|
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.