HIM 650 Discussion Question with Answers Topic 1 to 8

HIM 650 Health Care Data Management

HIM 650 Topic 1 DQ 1

Explain the differences between data, information, and a database. Describe the purpose of a database in health care andprovide an example of one utilized locally, statewide, and nationally.

HIM 650 Topic 1 DQ 2

The CMS Quality Measures Inventory is a compilation of measures used by CMS in various quality, reporting, andpayment programs. The measures are evidence-based criteria that indicate timeliness and effectiveness of care forspecific conditions. Consider the CMS core measures and the data used to support their reporting. Which do you believeare the easiest to collect and which do you think are the most difficult to collect?

HIM 650 Topic 2 DQ 1

Who would be the ideal candidate(s) from whom to elicit information during the requirements gathering and analysisphase of the database project? Explain why.

HIM 650 Topic 2 DQ 2

Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because thepatient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly,each order can include several medications, creating a 1:M relationship between order and medication.

Identify different entities from this scenario.

Create an entity-relationship diagram illustrating 1:1 and 1: many relationships.

Compare your ERD with another classmate's and discuss the differences each of you had.

HIM 650 Topic 3 DQ 1

What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables andcolumns (physical design) directly?

HIM 650 Topic 3 DQ 2

Programming language, such as JAVA, C, Python, and SQL, are commonly used in electronic health records anddatabases. Relational databases use structured query language (SQL) programming. SQL statements can be divided intotwo categories: data manipulation language (DML) and data definition language (DDL). Compare and contrast datamanipulation and definition language and provide an example and statement from each category.

HIM 650 Topic 4 DQ 1

Protecting data security, privacy, and integrity are important database functions. What activities are required in theDBA's managerial role of enforcing these functions? Using SQL statements, give some examples of how you would usethe data dictionary to monitor the security of the database.

HIM 650 Topic 4 DQ 2

Find two examples of data/security breaches that resulted in theft/loss/exposure of confidential data, preferably datarelated to health care. Describe the incidents and explain what could have been done to prevent or mitigate them.

HIM 650 Topic 5 DQ 1

Can you think of ways to validate the information from SQL queries or reports, to assure a level of accuracy in the

results? When, if at all, is it better to extract raw data instead of summary information and what are the best ways to

present any retrieved information (e.g., tables, diagrams, narrative)?

HIM 650 Topic 5 DQ 2

Data analytics is applied to discover trends and patterns in health care data, and it predicts future events based on thediscoveries. Compare and contrast data analytics, specifically the use of explanatory or predictive analysis, that youmight employ for analyzing health data.

HIM 650 Topic 6 DQ 1

Using resources provided in the study materials, answer the question: "What is R?" Discuss the impact of R on softwareand the health care industry. What are the benefits and challenges of R as compared to other programming languagesused in the health care industry?

HIM 650 Topic 6 DQ 2

Consider R language definitions using resources provided in the study materials. Define the term data structures orobjects in R and discuss several examples (e.g., vectors, lists, language objects, symbol objects, expression objects,function objects, NULL, etc.). All R objects have attributes. What is the purpose of attributes?

HIM 650 Topic 7 DQ 1

Discuss the impact of Python and other open source programming languages on electronic health records and the healthcare industry. What are the advantages of using open-source programming? What are the disadvantages?

HIM 650 Topic 7 DQ 2

Consider the functions and terminology within Python and other programming languages. Define the use of theseelements in Python: if statements, loops, lists, and indices. Why is syntax important in computer language?

HIM 650 Topic 8 DQ 1

Discuss the difference between supervised and unsupervised machine learning. Provide examples of how machinelearning is used in health care.

HIM 650 Topic 8 DQ 2

Discuss the analytic techniques used to analyze supervised and unsupervised learning. Provide an example.