Skip to main content

HIM 410: Health Care Database Design and Development

Course Description

This course will focus on integrateing health information functions such as content and format of records with database concepts and management. The course covers data definition modeling and definitions, database access, design, and implementation, in the context of a relational model. Course content focuses on the managerial issues for enterprise database processing. Fundamentals of database management are applied to health-information examples. (3 credits)

This course meets certain CAHIIM competencies for HIM Majors.

Prerequisites

  • ENG 101: English Composition 1
  • ENG 102: English Composition 2
  • ITE 102: Introduction to Computer Science

Student Learning Outcomes (SLOs)

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

  1. Identify components and functions of a database system and analyze the applications and benefits of databases to business requirements.
  2. Illustrate entity relationships and object modeling to document the information requirements and rules.
  3. Demonstrate the use of entity relationships and object modeling to normalize data into a relational design.
  4. Analyze database implementation and processing issues such as data manipulation techniques form design and report generation.
  5. Compare and contrast the implementation issues involved in various database architectures.
  6. Identify and explain management issues involved in the successful administration, maintenance, and security of the database upon a successful database implementation.
  7. Evaluate integration of intranet, Internet, multimedia and object-oriented database applications, and analyze the management issues involved in each. Compare and contrast DBMS programs and their respective management issues.

General Education Outcomes (GEOs)

Please check the applicable GEOs for this course, if any, by outcomes at GEO Category Search, or by subject area at GEO Discipline Search.

Course Activities and Grading

Assignments

Weight

Discussion (Weeks 1-7)

14%

HIM Weekly Exercises (Weeks 1-7)

14%

Lab Assignments (Weeks 1-7)

28%

Quizzes (Weeks 2, 4 & 6)

18%

Final Exam (Week 8)

26%

Total

100%

Required Textbooks

(Available through our online bookstore)

  • Kroenke, D.M. and D. J. Auer. Database Processing. 14th ed. Pearson Publishing, 2016. ISBN-13: 9780133876703

Additional Required Software

(Not available through bookstore. Additional fees may apply.)

Course Schedule

(Note: Course week runs Monday 12:00 am EST - Sunday 11:59 pm EST)

Week

SLOs

Readings and Exercises

Assignments

1

1

Topic: The Database User View

  • Reading:
    • Chapter 1: Introduction
    • Chapter 2: Introduction to Structured Query Language
  • Read assigned chapters
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 1 (Due by Sunday 11:59 pm EST)
  • Complete the Week 1 Lab Assignment - Introduction to MS Visio and Access (Due by Sunday 11:59 pm EST)

2

2

Topic: The Database Theory View

  • Reading:
    • Chapter 3: The Relational Model and Normalization
    • Chapter 4: Database Design Using Normalization
  • Read assigned chapters
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 2 (Due by Sunday 11:59 pm EST)
  • Complete the Week 2 Quiz (Due by Sunday 11:59 pm EST)
  • Complete the Week 2 lab assignment - Creation of MS Access Database (Due by Sunday 11:59 pm EST)

3

3

Topic: The Database Modeler View

  • Reading:
    • Chapter 5: Data Modeling with the Entity-Relationship Model
  • Read assigned chapter
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 3 (Due by Sunday 11:59 pm EST)
  • Complete the Week 3 lab assignment - Database Design Using Visio and Based on Data Requirements and Business Rules (Due by Sunday 11:59 pm EST)

4

4

Topic: The Database Designer View

  • Reading:
    • Chapter 6: Transforming Data Models into Database Design
  • Read assigned chapter
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 4 (Due by Sunday 11:59 pm EST)
  • Complete the Week 4 Quiz (Due by Sunday 11:59 pm EST)
  • Complete the Week 4 lab assignment - Database Design Based on Interpreting Data Requirements and Business Rules to Determine Realtionships (Due by Sunday 11:59 pm EST)

5

5

Topic: The Database Application View

  • Reading:
    • Chapter 11: The Web Server Environment
  • Read assigned chapter
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 5 (Due by Sunday 11:59 pm EST)
  • Complete the Week 5 lab assignment - Database Design by Normalizing Data Form Creation (Due by Sunday 11:59 pm EST)

6

6

Topic: The Database Administrator View

  • Reading:
    • Chapter 7: SQL for Database Construction
    • Chapter 8: Database Redesign
  • Read assigned chapters
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 6 (Due by Sunday 11:59 pm EST)
  • Complete the Week 6 Quiz (Due by Sunday 11:59 pm EST)
  • Complete the Week 6 lab assignment - Report Creation (Due by Sunday 11:59 pm EST)

7

7

Topic: Database Integration

  • Reading:
    • Chapter 9: Managing Multi-User Databases
    • Chapter 13: Database Processing for Business Intelligence Ssytems
  • Read assigned chapters
  • Participate in the Discussions
  • Review the Lecture material
  • Complete the HIM Exercise 7 (Due by Sunday 11:59 pm EST)
  • Complete the Week 7 lab assignment - Navigation System Creation (Due by Sunday 11:59 pm EST)
  • Prepare for the Final Exam

8

1-7

Topics: Conclusion, Review and Final Exam

  • Reading:
    • Review chapters from previous weeks to prepare for the final exam
  • Review previous chapters
  • Complete Final Exam (Due by Saturday 11:59 pm EST)
  • Complete Course Evaluation

Final Exam
Chapters 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 13
SLOs 1-7

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.