...﻿1. The sociological perspective, as a way of thinking about the world, includes the sociological imagination from C. Wright Mills, the beginner’s mind from Bernard McGrane, and the idea of culture shock from anthropology. Explain what all three of these concepts have in common.
Response: All three of these concepts have in common are the idea of breaking down social barriers to gain a different perspective on culture people and behaviors. When a person is in a new area where the culture is different it is betters to break down walls and keep an open mind they all deal with society and the differences they may have compared to the one a person is accustomed to.
2. Sociologists often have to decide if they are going to adopt a microsociological or a
macrosociological approach in any given project. Explain how these perspectives differ, paying
special attention to the different assumptions about how society works that are contained within each perspective. In other words, considering the starting point of each perspective, what do they seek to reveal?
Response: the way in Macrosociology and microsociology differ are that they deal with different societal issues for example Macrosociology deals with issues of bigger groups that affect effect the whole such as health care, war, and the economy and microsociology is looking more at the small everyday interactions with individuals or smaller groups. For examples family or schools and other small interactions...

...﻿RESIDES (PERSON_NAME, STREET, CITY, STATE)WORKS (PERSON_NAME, COMPANY_NAME, SALARY)ADDRESS (COMPANY_NAME, CITY, STATE, ZIP)MANAGES (PERSON_NAME, MANAGER_NAME)
3. Find all employees who live in the same city and street as their manager (3 pts)
SELECT R.PERSON_NAME, M.MANAGER_NAME, R.STREET, R.CITY, R2.STREET, R2.CITY
FROM RESIDES R, MANAGES M, RESIDES R2
WHERE R.PERSON_NAME = M.PERSON_NAME AND M.MANAGER_NAME =
R2.PERSON_NAME AND R.STREET = R2.STREET AND R.CITY = R2.CITY
4. Find all persons who do not work for any company (3 pts)
SELECT R.PERSON_NAME
FROM RESIDES R
EXCEPT
SELECT W.PERSON_NAME
FROM WORKS W
5. Find the number of employees for each of the managers (3 pts)
SELECT M.MANAGER_NAME, COUNT(*) AS ‘# of Employees’
FROM MANAGES M
GROUP BY M.MANAGER_NAME
6. Give all employees of ‘Nutiva’ a salary raise of 10% (2 pts)
UPDATE WORKS W SET SALARY = SALARY * 1.1
WHERE W.COMPANY_NAME = ‘Nutiva’
7. Layoff all employees of ‘LiveChat’ (3 pts)
DELETE FROM MANAGES
WHERE PERSON_NAME IN
(SELECT PERSON_NAME
FROM WORKS
WHERE COMPANY_NAME = 'LiveChat')
DELETE FROM WORKS
WHERE COMPANY_NAME = ‘LiveChat’
8. Give all managers of ‘Zubecon’ a 10 percent raise, unless their salary becomes greater
than $120,000. In such cases, give only a 4% raise. (5 pts)
UPDATE MANAGES M, WORKS W SET W.SALARY = W.SALARY*1.04
WHERE M.MANAGER_NAME = W.PERSON_NAME AND W.COMPANY_NAME =
‘Zubecon’
AND W.SALARY*1.1 > 120000;
UPDATE MANAGES M, WORKS W SET W.SALARY = W.SALARY*1.1
WHERE M.MANAGER_NAME = W.PERSON_NAME...

...Chapter 1: Intro
Independent Variable - variable you deliberately change during an experiment
Theory - explanation based on a large number of experiments
Hypothesis - educated prediction of cause and effect - what you test in an experiment
Control - a zero or set form of the independent variable
Dependent - variable you measure because you think it could change
7 characteristics: order, regulation, growth and development, energy processing, response to the environment, reproduction, evolutionary adaptation
Ecosystem - consists of all the organisms living in a particular area and the nonliving environmental components and interactions
Community - all the living organisms in an ecosystem
Population - localized group of individuals of a species
Species - population or group of populations whose members can reproduce fertile offspring
Taxonomy - science of classifying organisms
Domain &gt; Kingdom &gt; Phylum &gt; Class &gt; Order &gt; Family &gt; Genus &gt; Species
Prokaryotic Cells - do not have a nucleus, simple and small, bacteria
Eukaryotic Cells - has a nucleus, possess organelles separated by membranes, plants, animals, fungi
Protista - single-celled, colonial eukaryotes, contains nucleus and other membrane bound structures, mobile
Plantae - photosynthetic, multicellular autotrophs, cellulose cell walls, contain chlorophyll
Fungi - multicellular heterotrophs, digest and internalize food from their surroundings, immobile, chitin cell walls
Animalia -...