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 and columns (physical design) directly?
HIM 650 Topic 3 DQ 2
Programming languages, such as JAVA, C, Python, and SQL, are commonly used in electronic health records and databases. Relational databases use structured query language (SQL) programming. SQL statements can be divided into two categories: data manipulation language (DML) and data definition language (DDL). Compare and contrast data manipulation 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 use the 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 data related 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 the discoveries. Compare and contrast data analytics, specifically the use of explanatory or predictive analysis, that you might 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 software and the health care industry. What are the benefits and challenges of R as compared to other programming languages used 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 or objects 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 these elements 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 machine learning 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.