Go from good to great with a well-designed database.
Duration: 8 weeks
Credits: 3 credits
Prerequisite: HAD 560 Health Care Informatics
Health Information Management Systems Data and Infrastructure (HAD 562) is part of the Informatics track and provides a conceptual understanding of the role of a database. It highlights database terminology, design, and structure, as well as business needs, requirement building, and security.
Health Information Management Systems Data and Infrastructure Coursework
The HAD 562 course combines reading materials, discussion board postings, interactive projects and papers, and online resources to provide an analysis and case study of IT networks, internets, data interchange, data access, and data management. Throughout the course, you will see a general vein of recognizing how to use the information presented to benefit your business area.
Look and Learn
Watch this video to better understand the capabilities and concepts of a relational database.
What You’ll Learn in Health Information Management Systems Data and Infrastructure
As the Health Information Management Systems Data and Infrastructure course kicks off, concentration is on the types of databases and their uses. The basic concept of a database is reviewed, such as terminology, structure, and general design. Since a database is only as good as its design, it’s a great idea to build knowledge on this solid foundation. It’s essential to conceptualize — and then actualize. Before we even touch the database and all the design phases, it is necessary to create a clear mission statement and objectives.
In order for the coursework to continue down the conceptualization/development road, you’ll have to look back. To fully grasp how to build a better database, evaluation of the current system is recommended so you don't make design choices that were not beneficial in the past. You’ll make invaluable discoveries as you dig into the components of the database architecture. During this stage, general information about key database elements, along with an investigation of why and how to tie them back to business needs is conducted. Through the proper use of fields and tables, you’ll discern the best way to connect user needs and database structure.
To fully appreciate the importance of sound database structure, you’ll explore what a key is, and why they are so important to functionality and design. As you take a closer look at field specifications and characteristics, you’ll discover that databases are not a one-size-fits-all structure. A natural segue is evaluation of the importance of relationships within a database. You’ll examine the different relationships and their associated table and view functionalities to make better database decisions. Before the final decisions on database design can be made, the requirements, business rules, and data integrity need to be addressed by both the customer and designer. This course will highlight examples that illustrate why it is essential that designers ask good questions, and customers answer them thoroughly.
As the course concludes, ways to avoid ineffective database design are outlined with a “what not to do” list that leads to the "gray" area in building a database — when to bend the rules to achieve the desired results.
Over the eight-week duration of the course, you’ll be introduced to new topics and weekly themes. Sample weekly topics may include:
- Overview of Databases and Uses
- Database Design
- Evaluating the Current System
- Table Structure
- Detailing Fields and Keys
- Understanding Relationships Between Tables
- Business Rules, Requirements Gathering, and Data Integrity
- What NOT to do, and When There is Room for Bending the Rules
Course Learning Objectives
All Health Information Management Systems Data and Infrastructure coursework provides you with an appropriate level of understanding around the importance of having a quality database. Upon completion of the course, you’ll have the working knowledge to:
- Recognize what a database is and what it is used for.
- Understand how to achieve good database design.
- Have a strong understanding of the database terminology.
- Relate business needs to the structure of the database.
- Identify the difference between a well-designed database and one that has been poorly constructed.
Request More Information
To learn more about the online Master of Science in Health Administration curriculum from Saint Joseph’s University, including a track in Informatics, call (866) 758-7670 to speak with a program manager or request more information below.