Explain the two Data Control Language (DCL) statements, Grant, and Revoke with the correct syntax and appropriate examples of each statement.

Description
screen shots of working solution and sample output as evidence.
Task 1: Structure Query Language (SQL) [20%]
1. Explain the two Data Control Language (DCL) statements, Grant, and Revoke with the correct syntax and
appropriate examples of each statement.
2. Explain the term ACID in the relational database with appropriate examples
Task 2: Data Manipulation [50%]
Consider the above ERD diagram and write the following SQL statements.
(Each SQL statement has 5 marks)
Note: First you need to create the above database/tables
(See the SQL script in appendix to create the above database / tables and to insert the data).
1. Write an SQL statement to list all employees who are working in the Sales department for which the hire
date is between 1995 – 2008
2. Write an SQL statement to show all titles of employees who are getting more than £20000 salary and for
which the hire date was after 1985
3. Write an SQL statement to show the full names, salaries and gender of those in the HR department.
4. Write an SQL statement to show all employees’ names, department names and their departments’
managers.
5. Write an SQL statement to show a list of employees who were hired between 1980 and 1995 and whose
first name starts with A or S
6. Write an SQL statement to change the employee’s title who works in the finance department and whose
first name starts with ‘S’.
7. Write an SQL statement to increase the salaries of all employees up to 10 % for those who have been
working since 1997 and work in the Marketing department.
8. Write an SQL statement to delete employees’ record in the sales department and whose last name starts
with A or S
9. Create a database view to list the full names of all employees, salaries, their departments, and departments
manager
10. Create a database view to list all employees, departments and their departments’ managers of those who
were hired between 1990 and 2000.
Task 3: Database Testing [25%]

1. What is Database Testing and how Jet Airline’s database can be tested?
2. Develop the Jet Airline’s database testing template and provide screen shots of the testing process of the
following database constraints.
• Field size validation
• Null values
• Referential integrity (Primary/Foreign Key)
Task 4: Referencing and Bibliography [5%]
You are required to follow the Harvard referencing system when citing others’ work. An accompanying list
of references must also be provided as part of your report.

Is African Witchcraft relevant today?

Dissertation

Is African Witchcraft relevant today? 8,000 words

Introduction:

Subtopic 1: Trace history of African Witchcraft

• Henrietta Moore – African Witchcraft

Subtopic 2: Specificic case of African witchcraft – body and the Thames (African boy)

Subtopic 3: Newspaper articles on witchcraft

Key Writers:

• Adam Ashfort
• Henriatta moore – African witchcraft
• Max marick – witchcraft and sorcery
• Jean and john comorof

Define quality management, then using suitable quality management framework for Health and Social Care services, identify and evaluate factors effecting the quality of healthcare for patients

Download CQC inspection report PDF 199.27 KB (opens in a new tab)
All reports
We did not inspect any other services as this was a focused inspection in relation
to children’s and young people’s services. We did not enter any areas designated
as high risk due to COVID – 19. We continue to monitor the trust closely to identify
new and emergency risks and track the trust’s progress against their
improvement plan.
Using the children’s and young people’s framework, we inspected elements of
the key lines of enquiry of safe, effective, responsive and well-led. Our rating of
this location went down. We have rated the service as inadequate and have taken
enforcement action as a result of this inspection to promote patient safety.
We also used our urgent enforcement powers and placed conditions on the
trust’s registration in relation to: inadequate safeguarding systems that exposed
children and young people to the risk of abuse and harm; inadequate assessment
and management of risks relating to children and young people’s mental health,
those with learning disabilities and those with behaviours that challenged which
placed children and young people at risk of avoidable harm; and inadequate staff
training which meant children and young people with mental health and learning
disability needs were not being cared for by staff who had the skills to keep them
safe.
We also served a warning notice telling the provider they must make
improvements to ensure all care plans are individualised and meaningful for each
child and young person.
During our inspection we visited the children’s ward and two adult wards where
young people between 16 and 18 years of age had been admitted. These two
wards were the Acute Medical Assessment Unit (AMU) and an escalation ward
which was a temporary medical ward.
We reviewed the records of five children and young people who were receiving
care in hospital at the time of our inspection. We also reviewed the records of two
children and young people who had been detained under Section 2 of the Mental
Health Act 1983 at the trust during November 2020. Detention under Section 2 of
the Act means that a person has been legally detained for assessment of their
mental health; this can last for up to 28 days.
Exam Questions:
Please ensure that you read the full CQC report when preparing for your exam.
Question One
Define quality management, then using suitable quality management framework
for Health and Social Care services, identify and evaluate factors effecting the
quality of healthcare for patients at The Princess Royal Hospital. (30 Marks) 700
words
ASSESSMENT CRITERIA FOR Q1
Knowledge and understanding of the issues currently being experienced by The
Princess Royal Hospital.
Ability to conduct valid and relevant research
Ability to extract relevant information and draw balanced conclusions

Write an essay on international negotiation (Iran nuclear deal) applying analytical theories.

Description
Write an essay on international negotiation (Iran nuclear deal) applying analytical theories. Your task is to
identify, research and analyse aspects of the process, substance and strategies of the negotiation and critically
evaluate them drawing on the respective literature.

Critically assess the claim that evolutionary and comparative psychology are important for understanding human behaviour.

Essay Question 2: Critically assess the claim that evolutionary and comparative psychology are important for understanding human behaviour.

ASSESSMENT DETAILS

Essay question 2: Critically assess the claim that evolutionary and comparative psychology are important for understanding human behaviour.

Notes: You may discuss this question generally or you may focus on a specific behaviour to contextualise your answer e.g. reproductive or competitive behaviour. You can contrast evolutionary and non-evolutionary theory to help answer this question. You must draw on non-human research.

LEARNING OUTCOMES ASSESSED:

This assessment assesses the following module learning outcomes:

K1 The ability to explain and discuss key theories and evidence from the study of evolutionary psychology and animal behaviour

K2 The ability to discuss implications of research on animal behaviour for our understanding of human and non-human animals

Note that to pass the assessment, all learning outcomes must be met.

To what extent is Climate Change a result of human activities?

Assignment Research Workbook

Task 1 Choose Title

• Show your understanding of the essay title/question by identifying the topic and focus, and the task/instructions.
• Provide definitions of key terms/vocabulary

Task 2 References

Search online for 10 relevant and trustworthy academic sources and list them below using the Harvard Referencing System. Be sure to include links for all online sources.  (Harvard style)

Task 3 Source Evaluation

Conduct the CRAAP Test on one of your listed sources. Complete notes on the results in the following template:

(50 words)

Task 5 Note taking and Making

Make notes on at least three sources and record them below. Try to use varied note taking techniques and ensure that notes are summaries in your own words and not direct copies from original sources.

 (150-200 words)

1. Cornell Notes:

Task 6 Planning

Write an essay plan, this is only a plan and you may change it over time. Include a thesis statement highlighting the main argument. Include arguments for and against the thesis statement. Include citations to support the points you make.

(280-300 words)

How is physical education more than just physical activity or sports?

Description
Please read Task 1 Teaching health and physical education
Word-count: 1250 words, +/- 10%
THE TASK
Thinking of the ‘team, game, season and practice’ unit structure, respond to the following questions
incorporating reference to both your experiences from the PE workshop sessions (class discussions) Please
refer to the classroom observations in this document, The HPE Games and Dance booklet and the PE
Assessment 1 by friend (This has been submitted, please do not copy) and your academic reading:
1. How does this unit design and implementation address curriculum (content descriptors) in HPE?
2. How does this unit structure address a pedagogical issue in HPE (select one)?
3. How is physical education more than just physical activity or sports?
Please also read the other files I upload to have a better understanding of this unit and please use them as
references. Please make sure there is a table of the curriculum in the paper (no word count)
Marking schema
1. How does this unit design and implementation address the curriculum in HPE? Identifies and evaluates
specific connections between this unit design and the curriculum content descriptors in HPE (30%
weighting)
2. How does this unit design address a pedagogical issue in HPE (select one)? Identifies one specific
pedagogical issue in HPE and explains how this unit design may be used to address this issue (40%
weighting)
3. How is physical education more than just physical activity or sports? Identifies and explains differences
between physical education, physical activity and sports (not sport education) (15% weighting)
4. Incorporate reference to both experience and theory. Synthesizes experiences in workshop sessions with
students and at least six academic references in a clear and coherent writing style referenced using APA
(15% weighting)
Criteria
Curriculum in PE
How does this unit design address curriculum in HPE? Identifies and evaluates specific connections between
this unit design and curriculum in HPE (30% weighting)
Pedagogical issues in PE
How does this unit design address pedagogical issues in HPE? Identifies one specific pedagogical issue in
HPE and explains how this unit design may be used to address this issue (40% weighting)
Differences between PA,PE and Sport
How is physical education more than just physical activity or sports? Identifies and explains differences

What are the Effects of Psychological Capital

Topic:
What are the Effects of Psychological Capital

10 pages + well-structured + cited references
Description
The relationship between student engagement and positive psychology
Research about psychological capital and student engagement in higher education.
What exactly is psychological capital and what makes people engaged
What does engagement look like
Factors that effect engagement

How are the demographics or risk factors for becoming a criminal and victim related?

Craig was raised without a father, but his mother, Donna, a strong Christian lady, always loved her son. Because she was a single parent, Craig was often left with babysitters while she worked two jobs or was involved in her prison ministry. When the sitter could not be there on some days, Donna’s neighbor Steve, who worked from home, would take him and not charge her. Donna was always grateful for the extra help and in return baked bread and pies for Steve. What Donna did not know, of course, was that Steve was molesting and raping Craig, who was 6 years old. Craig could not tell his mother of his terror of going to Steve’s house because Steve warned him that if he ever told anyone Steve would kill the puppy that was living in his home. Little Craig loved that puppy, so he never told. At age 11, Craig began setting fires that escalated over the years. At age 13, he was raped by a 26-year-old male. Craig engaged in other crimes, including stealing a police car at age 15, impersonating a police officer, sexual assault on a 12-year-old boy, prostitution, theft, and burglary. He took trophies from his favorite fire crimes by going to the crime scenes at night looking for anything he could add to his collection. Eventually he was apprehended and confessed to the fires and went to prison for several years. He is now back on the streets and has had considerable difficulty in keeping jobs for more than a few months. Craig is determined not to return to prison. He currently resides with his aging mother.   Analyze your selected case study: What demographics or risk factors (e.g., acute, direct, proxy, short and long-term) are involved that may have contributed to the person becoming a victim or offender? How are the demographics or risk factors for becoming a criminal and victim related? How are they different? How would the demographics or risk factors vary in another country? If an individual reflects the data supporting the likelihood of becoming a criminal or victim, does that guarantee the outcome? Support your responses with evidence from the Learning Resources or other academic material.

What was your reaction to learning about the West Fertilizer Company Explosion in West, Texas?

Instructions: Please answer the following questions by writing a complete, thoughtful paragraph directly under each question. You may type directly into this Word document. The final product should be double-spaced, written in 11-point font with 1-inch margins, and at least four pages in length. Think critically about how you are affected by your participation in the interprofessional activity and thoughtfully respond to each of the questions below. What was your reaction to learning about the West Fertilizer Company Explosion in West, Texas? What did you learn about large plant explosions that pertains to your future practice of public health (or your profession, if you are not a public health student)? What was your reaction to learning about interprofessional teams? What did you learn about working in interprofessional teams that you can apply in your current/future professional practice? In what situations do you think you may have to work in interprofessional teams during your career? What would you change about your contributions if you could repeat the experience?  What would you change about your team members contributions if you could repeat the experience? Which knowledge, skills, or attitudes do you think you will apply in the future because of this IPE experience? Please provide specific examples or a short paragraph describing the setting and scenario you have in mind. Please be specific to the career in public health or health care that you are pursuing. How do you think that interprofessional training can improve the delivery of health services to the populations we serve? Any additional thoughts or comments you would like to share?