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:
- Identify components and functions of a database system and analyze the applications and benefits of databases to business requirements.
- Illustrate entity relationships and object modeling to document the information requirements and rules.
- Demonstrate the use of entity relationships and object modeling to normalize data into a relational design.
- Analyze database implementation and processing issues such as data manipulation techniques form design and report generation.
- Compare and contrast the implementation issues involved in various database architectures.
- Identify and explain management issues involved in the successful administration, maintenance, and security of the database upon a successful database implementation.
- 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.
Course Activities and Grading
Note: A "C" grade or higher must be earned to pass this course.
| Letter Grade | Percentage |
| A | 93.0-100.0 |
| A - | 90.0-92.9 |
| B+ | 87.0-89.9 |
| B | 83.0-86.9 |
| B - | 80.0-82.9 |
| C + | 77.0-79.9 |
| C | 73.0-76.9 |
| F | 72.99% and below |
| 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 Charter Oak State College's Book Bundle
- 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.)
- Microsoft Visio 2016 (Free trial)
- Microsoft Access 2016 (Free trial)
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
|
|
2 | 2 | Topic: The Database Theory View
|
|
3 | 3 | Topic: The Database Modeler View
|
|
4 | 4 | Topic: The Database Designer View
|
|
5 | 5 | Topic: The Database Application View
|
|
6 | 6 | Topic: The Database Administrator View
|
|
7 | 7 | Topic: Database Integration
|
|
8 | 1-7 | Topics: Conclusion, Review and Final Exam
|
|
Final Exam | |||
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.