– 650 words max – More descriiptive (if needed) – Making the point/takeaway of my experience clear (Takeaway: I

QUESTION 1 With SQL, how do you select all the records from

QUESTION 1

With SQL, how do you select all the records from a table named “Persons” where the “LastName” is alphabetically between (and including) “Hansen” and “Smith”?

None of the above

SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Smith’

SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName>’Smith’

SELECT LastName>’Hansen’ AND LastName<’Smith’

1 points   

QUESTION 2

To display the detail of employee having ‘n’ in their name in descending order of salary the correct SQL statement is :

SELECT * FROM employee ORDER BY SAL DESC WHERE emp_name LIKE %n%;

SELECT * FROM employee WHERE emp_name LIKE n% ORDER BY SAL ;

SELECT * FROM employee WHERE emp_name LIKE %n% ORDER BY DESC SAL;

SELECT * FROM employee WHERE emp_name LIKE %n% ORDER BY SAL DESC;

1 points   

QUESTION 3

Which SQL statement inserts data into a table called Projects?

SAVE INTO Projects (P_Name, P_Description) VALUES (‘Content Development’, Social media content development project’)

INSERT INTO Projects (P_Name, P_Description) VALUES (‘Content Development’, ‘Social media content development project’)

INSERT Projects (‘Content Development’, Social media content development project’)

INSERT Projects VALUES (‘Content Development’, Social media content development project’)

1 points   

QUESTION 4

Which statement is valid? 

ALTER TABLE EMPLOYEE CHANGE (first_name VARCHAR2 (3000));

ALTER TABLE EMPLOYEE MODIFY (first_name VARCHAR2 (3000));

ALTER TABLE EMPLOYEE MODIFY (first_name CHAR2(3000));

ALTER TABLE EMPLOYEE CHANGE (first_name CHAR2(3000));

1 points   

QUESTION 5

What is a valid create table statement?

Create table emp (id integer(3));

Create table emp (id integers(3));

Create table emp add(id integer(3));

Create table emp modified (id integer(3));

1 points   

QUESTION 6

Please answer the following question with the following details.

Table Name: EmployeeInfo

Fields Name: EmpID, EmpFname, EmpLname, Department, Project, Address, DOB, Gender

Which of the following  query can fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName.

SELECT UPPER(EmpFname) AS EmpName FROM EmployeeInfo table;

SELECT UPPER(EmpFname) AS EmpName FROM EmployeeInfo;

FETCH UPPER(EmpFname) AS EmpName FROM EmployeeInfo;

FETCH UPPER(EmpFname) AS EmpName FROM EmployeeInfo table;

1 points   

QUESTION 7

Please answer the following question with the following details.

Table Name: EmployeeInfo

Fields Name: EmpID, EmpFname, EmpLname, Department, Project, Address, DOB, Gender

Q. Which of the following query can fetch the number of employees working in the department ‘HR’.

SELECT COUNT(*) FROM EmployeeInfo FIND Department = ‘HR’;

SELECT SUM(*) FROM EmployeeInfo WHERE Department = ‘HR’;

SELECT COUNT(*) FROM EmployeeInfo WHERE Department = ‘HR’;

SELECT SUM(*) FROM EmployeeInfo TABLE WHERE Department = ‘HR’;

1 points   

QUESTION 8

Please answer the following question with the following details.

Table Name: EmployeeInfo

Fields Name: EmpID, EmpFname, EmpLname, Department, Project, Address, DOB, Gender

Q. Which of the following  query can retrieve the first four characters of EmpLname from the EmployeeInfo table.

SELECT SUBSTRING(EmpLname, 1, 4) FROM EmployeeInfo;

SELECT SUBSTRING(EmpLname, 1 TO 4) FROM EmployeeInfo;

SELECT SUBSTRING(EmpLname, 4 CHAR) FROM EmployeeInfo;

SELECT SUBSTRING(EmpLname, FIRST 4) FROM EmployeeInfo;

1 points   

QUESTION 9

Please answer the following question with the following details.

Table Name: EmployeeInfo

Fields Name: EmpID, EmpFname, EmpLname, Department, Project, Address, DOB, Gender

Q. Which of the following  query can fetch details of all employees excluding the employees with first names, “Sanjay” and “Sonia” from the EmployeeInfo table.

SELECT * FROM EmployeeInfo WHERE EmpFname =! (‘Sanjay’,’Sonia’);

SELECT * FROM EmployeeInfo WHERE EmpFname NOT IN (‘Sanjay’,’Sonia’);

SELECT * FROM EmployeeInfo WHERE EmpFname NOT (‘Sanjay’,’Sonia’);

SELECT * FROM EmployeeInfo WHERE EmpFname NOT = (‘Sanjay’,’Sonia’);

1 points   

QUESTION 10

Please answer the following question with the following details.

Table Name: EmployeeInfo

Fields Name: EmpID, EmpFname, EmpLname, Department, Project, Address, DOB, Gender

Q. Which of the following query can fetch all the records from the EmployeeInfo table ordered by EmpLname in descending order and Department in the ascending order.

SELECT * FROM EmployeeInfo ORDER  EmpFname desc, Department asc;

SELECT * FROM EmployeeInfo ORDER BY EmpFname desc, Department dsc;

SELECT * FROM EmployeeInfo ORDER  EmpFname desc, Department dsc;

SELECT * FROM EmployeeInfo ORDER BY EmpFname desc, Department asc;

Assignment 2 – Sociological Imagination and the Future of Work/Education. Due the

– 650 words max – More descriiptive (if needed) – Making the point/takeaway of my experience clear (Takeaway: I Writing Assignment Help Assignment 2 – Sociological Imagination and the Future of Work/Education. Due the end of week 7.  Assignment should be a minimum of 700 words, not including the reference list. Worth 16% of final grade.

This assignment assumes that you have studied the Learning Resource materials for week 6. It may help you to go back and review your Discussion post and the Learning Resource materials for Week 1.  Please structure your assignment as an essay, not as a list. Be sure that your assignment has an introduction and a conclusion. Your assignment should be structured as follows:

Part 1: Introduction

In a single paragraph, provide the reader with the key points you will be addressing in this assignment.

Part 2 (300-400 words): Sociological imagination

Briefly discuss and define the sociological imagination, which you learned about in Week 1 of this course.

Remember that the sociological imagination is the ability to see things socially and how they interact with each other.

Identify and explain at least two broader social condition(s) related to education, the workforce, and/or the economy that might affect your personal future plans for work and/or education.  You might find a relevant social condition in your Week 6 Learning Resources.  Some examples of social conditions are automation in the workplace, polarization of the workforce, globalization, and the wage gap between men and women.

The gender wage gap is a broader social condition that may affect future career plans. The wage gap between men and women has a significant impact on women’s ability to achieve upward social mobility. This is not just an individual issue; it is also a societal issue. Societies that have significant levels of gender inequality are less cohesive and they have higher rates of deviant behavior. Gender inequality in the workplace leads to hostile work environments, which in turn may negatively impact employee performance and organizational goals. According to Stamarski and Hing (2015), organizations that have women in key leadership positions have greater gender pay equity. In contrast, organizations that have few women in leadership positions have a greater gender wage gap.

Then go to the “Future of Work” page (https://www.pewresearch.org/topic/economy-work/business-workplace/future-of-work/) or the “Education” page (https://www.pewresearch.org/topic/other-topics/education/) of the Pew Research Center and find an article related to one of the social conditions that you identified.  What three key research findings in the article do you find most relevant to this social condition, and why are they relevant?

The article, Women in majority-male workplaces report higher rates of gender discrimination, demonstrates the negative impact that gender discrimination has on women’s experiences in the workplace. One key research finding is that women who report that they work mostly with men earn less than their male colleagues who are doing the same job. However, women who report that they work in a gender diverse workplace or mostly with women experience greater pay equity.

Part 3 (200-300 words): Sociological perspectives

Use one of the three main sociological perspectives (functionalism, conflict theory, or symbolic interactionism) to analyze one of the social conditions that you chose.

First, briefly explain the perspective. 

Feminist theory is a type of conflict theory that examines how gender influences the experiences of men, women, and non-gender conforming populations differently. Feminist theory explains the forces that maintain gender inequality. For example, in patriarchal societies women are ranked lower compared to men.

Then answer the question: How might you use that perspective to explain/analyze the social condition?  For example, if you choose the condition of a wage gap between men and women, how might a conflict theorist explain why this gap exists in society?

Feminist theory explains that the gender wage gap exists in order to keep women subordinate to men. Feminists also argue that the work that women do is not considered to be as important as the work performed by men. For instance, female dominated professions such as nursing, teachers, and child care workers pay significantly less compared to comparable male dominated professions. Men who work in female dominated professions still earn more than their female colleagues. As a result, women do not receive comparable pay compared to men. According to O’Brien (2015), male teachers earn a median of $1,096 a week, whereas women earn $956 — about 87 cents to the man’s dollar.

Part 4: Conclusion/Reflection

In a final thorough paragraph, explain what you learned from this assignment. Based on what you have learned about sociology and social conditions, how might you modify your plans for future education and career? Please explain one key aspect of your plans for the future that you might change because of what you learned in your sociology course this term.  If you wouldn’t change anything, explain why.

As a woman, I would definitely research the diversity and inclusion mission and/or strategies of potential employers. Based on the information presented in this essay, it would be important to seek employment with an organization that has transparent hiring and promotion policies.

Part 5: Reference List

Your Reference List should include all the resources that you have cited in your Assignment.  At the very least, it should include the reference information for the Week 1 and 6 Learning Resources, as well as the Pew Research article that you discussed.

References

Mills, C. W. (2000 [1959]). Chapter 1: The promise, in The sociological imagination. Oxford University

Press. (Pages 3-14 only) http://ezproxy.umgc.edu/login?url=https://search.ebscohost.com/login.aspx?direct=true&db=nlebk&AN=316643&site=eds-live&scope=site

O’Brien, S. (2015). 78 cents on the dollar: The facts about the gender wage gap. CNN Money. Retrieved

from http://money.cnn.com/2015/04/13/news/economy/equal-pay-day-2015/

Stamarski, C. S., & Son Hing, L. S. (2015). Gender inequalities in the workplace: the effects of

organizational structures, processes, practices, and decision makers’ sexism. Frontiers in psychology, 6, 1400. https://doi.org/10.3389/fpsyg.2015.01400

University of Maryland Global Campus. (n.d.). Week 1. Introduction to Sociology. Document posted in

UMGC SOCY 100 online classroom, archived at https://learn.umgc.edu

University of Maryland Global Campus. (n.d.). Week 6. Education, work, and the economy. Document

posted in UMGC SOCY 100 online classroom, archived at https://learn.umgc.edu 

This assignment will use Turnitin to assess academic integrity. Please see your syllabus for more information on how Turnitin will be used in this class.

Identify the main argument of each resource and briefly describe what the

Identify the main argument of each resource and briefly describe what the selection is about in enough detail to show you have read it. Note that saying something like “this article examines…” is not the same as clearly stating what an author is trying to argue or establish; most of our readings, with occasional exceptions, will have some kind of argument, even if you have to dig for it. At the end of your reading abstract, I also want you to include a sentence or two discussing how (or whether) the selections for that week fit together – for example, do they contradict each other, or do they work together to give you a better understanding of some topic?