Reference no: EM131090729
Data Modeling and Database Design
The use of databases can significantly improve an organization's ability to access, share, and apply relevant information. However, despite the wealth of data available in a database, its value is greatly dependent on its design. Designing a database that creates logical data relationships for the end users ensures the best conditions for developing information and knowledge for real-world application.
This Discussion focuses on the importance of thoughtful data modeling and database design. You also consider strategies for mitigating design issues.
To prepare:
Review the information in this week's Learning Resources on data modeling and database design.
Reflect on how you have seen these concepts evidenced in a health care organization's use of databases.
Consider the benefits and challenges of data modeling, both generally and within an organization with which you are familiar.
Review the six different issues with database design described in "Data Aggregation: A Case Study," found in this week's Learning Resources.
Have you experienced any of these in your own database use? How could an organization avoid such issues through planning?
Select one of the issues and conduct additional research using the Walden Library to locate an article that addresses your selected issue and provides insights into how it can be avoided.
Post by tomorrow 6/14/16 550 words in APA format and 3 references
1) The benefits and challenges of data modeling both generally and within a health care organization.
2) Describe the database design issue you selected and briefly summarize your findings (include your reference).
3) Suggest strategies for how this issue could be mitigated in the database planning phase.
Required Resources
Readings
Coronel, C. & Morris, S. (2015). Database systems: Design, implementation, and management (11th ed.). Stamford, CT: Cengage Learning.
Chapter 2, "Data Models" (pp. 34-66)
During database design, the objective is to formulate a system where data is stored for optimum access and use. By providing a history of data modeling's development, the authors build an understanding of the contemporary database models introduced in this chapter.
Chapter 9, Sections 9.4-9.9, "Database Design" (pp. 431-451)
This section of Chapter 9 deals with conceptualizing database design. It explores all the factors and conditions that need to be considered to ensure that the final product satisfies the end user.
Rux, E., & Borchert, T. (2010). You have how many spreadsheets? Computers in Libraries, 30(8), 21-25.
Retrieved from the Walden Library databases.
In this article, the authors provide an example of the development of their database, revealing the successes and missteps they encountered during the process. Managing electronic resources requires a system designed to accommodate the storage and flow of necessary data.
Roberts, A. L., & Sewell, J. P. (2011). Data aggregation: A case study. CIN: Computers, Informatics, Nursing, 29(1), 3-7.
Retrieved from the Walden Library databases.
The authors of this article address the need for nurses to adapt to database use. As a condition of the HITECH Act, changes in nursing instruction, data capturing, and health care procedures are required to accommodate the increasing reliance on electronic health records in nursing.
Use the supply and demand analysis
: Use the supply and demand analysis, discuss the impact of worker shortage, which is nowadays widely observed in many Chinese cities, on prices and consumers’ living costs. Try to consider the effect of worker shortage on firm production and consumer ..
|
System protect patient privacy medical record
: The length of the paper is 7 pages and I want to write on the areas of "Does computer system protect patient's privacy medical record?" Please follow this paper outline:
|
Research questions for the identified problem or opportunity
: HI6007 - Analyzing the Dynamic Supply Chain in Food Retailing Industry in Australia - Will the study involve human subjects who are legally or otherwise not in a position to give their valid consent to participate such as children, prison inmates,..
|
How will results and ongoing communications be provided
: Provide specific definitions of measures of progress towards obtaining the intended goals and a description of the tools that you would use to measure progress. What strategies will be used to measure success, and how will adjustments be made shou..
|
Have you experienced any of these in your own database use
: Reflect on how you have seen these concepts evidenced in a health care organization's use of databases. Consider the benefits and challenges of data modeling, both generally and within an organization with which you are familiar.
|
Create loop application
: Create your own unique While-End or (For End) repetition C code. You decide the theme. Be sure to provide an overview of what your repetition structure is doing. Please keep the design simple for this exercise. Just a few lines of code is all that..
|
What should be included in the plan of care
: What techniques are helpful to incorporate in assessing a patient in this age group? What are some of the more common conditions that may cause seizure activity in this age group?
|
Unspecified number of scores
: Write a program that reads an unspecified number of scores and determines how many score are above or equal to the average and how many scores are below average. Enter a negative number to signify the end of the input. use c++ to write the program..
|
The assumption ofmultilevel model binary data
: Hi,The nature of my data in my thesis is clustering (students within college within universities) and students' responses is binary,so I have used Multilevel Generalized Linear Model> (logistic regression) in R with (glmer) function in (lme4) pack..
|