Databases Vs. Spreadsheets/Relationships 2

    

Respond to one of the following in a minimum of 175 words: 

Discuss the differences between storing data in a spreadsheet verses storing data in a database.

In what business scenarios might one approach be superior to the other?

What are the pros and cons of each approach?

Why do you think many businesses today use both spreadsheets and databases to manage their data? 

Databases Vs. Spreadsheets/Relationships 1

  

Respond to one of the following in a minimum of 175 words: 

Share at least one real-world example of the following types of data relationships:

1:1

1:M

M:N (many-to-many)

Your example can be from work, school, a hobby, or daily life.

Discuss why you think making the distinction between these types of relationships is important for database designers. How does each of these types of relationships affect the complexity of storing and retrieving data? How do database architects apply the concepts of primary and foreign keys to each type of data relationship?

Case Of Elderly Couple

  1. Consider Lydias and Johns cognitive and physical limitations as well as their social support. If you were presenting this case to a team of other human services providers, what developmental theories, concepts, and principles help explain this case? 
  2. What other information might you need to fully evaluate the situation in which Lydia and John live?
  3. If you were the protective service worker, what are the options for this couple? Identify several feasible plans with explanation and support from a source of information. Include the risks and benefits of each option. Then, identify what your final recommendation would be and why.

Case Study 

Lydia and John were a couple in their nineties who lived in their own home and had been married over sixty years. Both were confused and forgetful. They had two sons who were in their seventies and lived in nearby towns. One son was estranged from them. The other was somewhat involved in their lives, but he had a mentally ill wife and health problems of his own to deal with. The couple first came to the attention of a protective service worker when John was hospitalized after a fall. When left on her own, Lydias confusion became more pronounced. A referral was made for home care services, but, when a worker went out to assess the couple, their son was present and refused services. Based on concerns of benign neglect, a protective services report was issued. A caseworker investigated and substantiated the report, citing the sons interference with services and the couples own inability to provide adequate care for each other. The protective services worker found both John and Lydia to be very forgetful and somewhat confused, though Lydia was more impaired. Due to their increased physical frailty, they had been using only the first floor of their home. Since the bedrooms and bathroom were upstairs, the living arrangement presented several problems for the couple. Lydia had a regular bed, but John was sleeping on a cot. The low height of the cot caused him to lose his balance easily, resulting in several falls. Since there was no toilet downstairs, they were using a bucket in the kitchen and emptying it outside. They were unable to maintain their home and conditions became unsanitary. The son tried to help, but he had his own limitations. The elderly couple was well able to afford assistance, but they did not want to spend the money. Furthermore, even though the son who helped with paying the bills was not taking advantage of his parents financially, he was obviously concerned with preserving his inheritance. Meanwhile, John and Lydia were extremely conservative in terms of how they chose to spend their money; they insisted they could not afford help. 

Term Project

 

Upload your Term Project Paper here. You may write on any topic related to technology security.

You must produce a minimum of a 10 pages paper. You must use a minimum of 5 references, citing the references where you used the material within the paper itself.

– Assure you are citing in APA format

-You must use a minimum of one graphic or image (may use a table)

– Double space the paper

– You must use APA formatting (6th Edition)