Project Management

 

 

 

7.1, 7.2, 7.3, 7.5, 7.6, 7.7, 8.1, 8.2, 8.5, 8.6
When you have run your SQL in the MindTap system, copy and paste the SQL into a MS Word document. Indicate the problem number associated with your
SQL. For instance:
Problem 7.1: SELECT [rest of your SQL];
Problem 7.2: [your SQL];
Problem 7.3: [your SQL];

Start each problem on a new line in your MS Word document. Submit your MS Word document via the assignment link.
Resources: These are the same resources used for the Week 4 Discussion Board and can be found in MindTap in the Week 4 Discussion Board module.
• Textbook: Module 7 – Introduction to Structured Query Language
• Video: Module 7 – SELECT: Projection (2:48 min.)
• Video: Module 7 – SELECT: Column Aliases (4:20 min.)
• Video: Module 7 – SELECT: Formulas (4:50 min.)
• Video: Module 7 – SELECT: Concatenation (6:56 min.)
• Video: Module 7 – SELECT: Suppressing Duplicates (2:18 min.)
• Video: Module 7 – FROM: JOIN ON (3:15 min.)
• Video: Module 7 – FROM: JOIN More Than Two Tables (3:06 min.)
• Video: Module 7 – FROM: Inner and Outer Joins (4:31 min.)
• Video: Module 7 – FROM: Table Aliases (3:21 min.)
• Video: Module 7 – WHERE: Equalities and Inequalities (4:39 min.)
• Video: Module 7 – WHERE: Logical Connectors (3:53 min.)
• Video: Module 7 – WHERE: Case Sensitivity (3:56 min.)
• Video: Module 7 – ORDER BY (3:29 min.)
• PowerPoint: Module 7 Review charts
• Textbook: Module 8 – Advanced SQL
• Video: Module 8 – CREATE TABLE Basics (6:24 min.)
• Video: Module 8 – CREATE TABLE Implementing Relationships (3:53 min.)
• Video: Module 8 – INSERT Basics (4:54 min.)
• Video: Module 8 – INSERT Insert with an Attribute List (3:39 min.)
• Video: Module 8 – UPDATE Updating Ex

 

 

 

 

Sample Solution

processing model also referred to as the Dual Process Model of Coping with Bereavement by Stroebe and Schut (Death Studies, 1999), is a natural process that helps us to find a balance between facing the reality of the loss (loss-orientation) and learning to re-engage with life after the loss (restoration-orientation). It is in finding the balance may explain why grief is often described as an emotional roller coaster. Many people experience a back and forth between both loss-orientation and restoration-orientation responses, for example moving between classic grief reactions, crying, anger, depression etc. and learning how to manage finances, form new relationships and taking on roles that the dead person may have done, for example looking after the children. It is in the restoration-orientation phase that grieving people may focus on day-to-day tasks and get temporary relief from the emotional drain of the loss. It is possible to get a sense of the dual processing model when working with C as she is angry and depressed but has days where she is able to focus on the new baby’s imminent arrival. With further work once the baby has arrived, as so not to put any unnecessary stress or upset upon C before the baby is born, it may be possible to encourage her to explore her own dual process of grief, alongside learning how to care for her baby with the support of the staff at the mother and baby unit. N has experienced a normal dual process of grieving as she has days where she is feeling low especially when it comes to significant events such as birthdays, anniversaries and holidays, but has expressed that she is more positive towards Christmas this year as she has her daughter and the new baby living at home with her, therefore she is able to focus on them rather than her losses. It is my intention to work alongside N to encourage her to explore her own dual process. Therese Rando (1993) developed the six R’s of grieving and according to Rando, in order to achieve the six R’s, a person must Recognise the loss by acknowledging and understanding the death, React to the separation by experiencing the pain, give some form of expression to the psychological reaction of the loss and identify the secondary losses, Recollect the relationship with the loved one by remembering them realistically and re-experience the feelings they had for them, Relinquish the old attachments to the deceased, Re-adjust and adapt to their new world without forgetting their old one by developing a new relationship with the deceased, adopt new ways of being in the world without their loved one and form a new identity and finally Re-invest. Rando stated that complicated mourning is present whenever there is some compromise, distortion, or failure of one or more of the six “R” processes of mourning. It is clear from working with C that her grief is complicated and so some sort of compromise in one or more of the six R’s is probable

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.