Assignment: Relational Database Query

Assignment: Relational Database Query
Assignment: Relational Database Query
Week 2 MS Access (or OpenOffice Base for MAC Users): Relational Database Query
PC Users:
Complete the related MS Access query training tutorials located in the Assignment Resources below.
Using the relational database created during the first week, run a query to receive meaningful data output (e.g., running a query to filter patients with a specific diagnosis).
Submit a screenshot and your query results for grading.
Mac Users:
Watch the OpenOffice Base Creating Queries video located in the Assignment Resources below.
Using the relational database created during the first week, run a query to receive meaningful data output (e.g., running a query to filter patients with a specific diagnosis).
Submit a screenshot and your query results for grading.
Question 2
Week 1 discussion
DQ1
Use examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment? Why?
DQ2
Describe the basic features of the relational data model and discuss their importance to the end user.
Week 2 discussion
DQ1
Is data more protected in a cloud-based database management system (DBMS) or stored locally? Why?
DQ2
List the common sources of database failures and discuss how the risk of database failure can be mitigated for one of the sources.
Week 3 discussion
DQ1
What are decision support systems, and what role do they play in the business environment? Give an example of decision support systems used in health care.
DQ2
Discuss how one of the two listed data analytics tools in the readings (explanatory and predictive) can be applied in health care. Give a specific use example.
Week 4 discussion
DQ1
Discuss a health care data security breach that occurred within the last five years. Discuss the causes, what measures could have been in place to prevent it, and the implications of the data security breach.
DQ2
Discuss the differences between cloud-based storage and local server storage. Which offers the best solution? Why?
Week 5 discussion
DQ1
Discuss the challenges associated with “free-text” clinical information (e.g., Nursing Progress Notes).
DQ2
Compare and contrast supervised and unsupervised learning as discussed in your readings. Give specific examples to explain both.
Week 6 discussion
DQ1
Describe social media analytics and give one example of its application in health care.
DQ2
Examine one major challenge faced by researchers and practitioners with temporal healthcare data mining and propose a future research direction.
Week 7 discussion
DQ1
Discuss how clinical decision support systems (CDSS) can be used to improve patient outcomes in health care. Provide a specific example.
DQ2
Discuss how clinical decision support systems (CDSS) can be used to improve patient outcomes in health care. Provide a specific example.
Week 8 discussion
DQ1
Discuss one future trend of data analytics and its implication in health care. Provide specific examples.
DQ2
How can data visualization evolve to better facilitate decision-making in health care