Identifying the statement and the syntax.

 

Select one of the following SQL statements. You need to identify the statement and the syntax. Provide an example of the SQL statement using a table and
attributes from the database you are designing for your data management project. Please don’t replicate a statement that has already been identified. Review
the discussion board before submitting your work to see what fellow students have submitted. Please respond to at least two other students by Sunday
11:59 pm with comments, questions, or suggested improvements for their SQL.
• Select with Where clause
• Select with Order by clause
• Select with Group by clause
• Select with Having clause
• Select using (Count (*))
• Insert
• Update using columns
• Update without columns identified
• Delete
• Create Schema
• Create Table
• Create View
• Create Index
• Alter Schema
• Alter Table
• Alter View
• Alter Index
• Drop Schema
• Drop Table
• Drop View
• Drop Index
• Create Trigger (just basic structure) you don’t have to provide example with this one
• Create Procedure (just basic structure) you don’t have to provide example with this one
Resources: All resources are in MindTap
• 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 Existing Data (2:48 min.)
• PowerPoint: Module 8 Review charts

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