Author: chris

You are hired by AdventureWorks as a Database administrator. You are required to integrate some Database script solutions into their existing database (AdventureWorksLT2012) to modify data from within the database.
Using the AdventureWorksLT2012 database, write a SQL DML statement that will modify the data. Base it on the following requirements:
Query #1: Write a script to create a new Product Category called ‘Shoes’. This category belongs under the category Clothing. Only ParentProductCategoryID and Name are required. The system will assign values for the other fields. Use a subquery to find the value for ParentProductCategoryID.
Query #2: Provide a SELECT statement to show that the new Product Category Shoes was inserted.
Query #3: Add the following two products in the data base for your new Shoes category. Insert other appropriate column values as necessary. Use a subquery to find the ProductCategoryID for Shoes.

Query #4: Provide a SELECT statement to show only the newly inserted products using a subquery to find the ProductCategoryID for Shoes.

Name    Product Category    Product Number    Standard Cost    List Price    Sell Start Date
Men’s Black Size 10    Shoes    SH-1000    30.99    55.99    Today’s date
Woman’s White Size 38    Shoes    SH-2000    28.99    50.99    Today’s date
Query #5: Utilizing a subquery, provide a script to display all product fields for products in the Mountain Frames Product category that are silver. Look at the List Price.
Query #6: Utilizing a subquery, increase the list price by 5% for products in the Mountain Frames Product category that are silver. Rerun Query #5 and verify that the price has changed.
Query #7: Utilizing a subquery, change the unit price discount in the Sales Order Details table on all orders of products of an ordered quantity of more than 15 to that of the largest discount ever given on any product.
Query #8: You have decided against the new Fast-Food category. Provide SQL scripts to delete the Fast-Food category as well as any products assigned to that category. Use a subquery to delete the products.

Discuss the relation between how current event are reported and the way history is tought, and ho we view the news and ho we view how history is tought…

in 2 pages single space MLA format cover this subject with quality, good, and intresting ideas, basically upon couple of videos you will watch, so the videos will be resource and also a book called ” lies my teacher told me ” from the begining of the book till the chapter “gone with the wind” that is three chapters

When Southwest Airlines first taxied onto the runway of Dallas’s Love Field in 1971, industry gurus predicted it would be a short trip to bankruptcy for the Texas-based airline.  But the first short-haul, low-fare, high-frequency, point-to-point carrier took a unique idea and made it fly.  Today, Southwest Airlines is the most profitable commercial airline in the world.

But it took more than a wing and a prayer for Southwest to soar to such lofty altitudes.  It took a maverick spirit.  From the beginning, Southwest has flown against convention.  Southwest’s fleet of 737s, considered by many the safest in the industry, still makes only short hauls to 45 cities.  The average flight distance is 394 miles.  The airline does not give seat assignments and the only food it serves passengers is a “snack pack.”  But what Southwest may lack in amenities, it seems to more than make up for in what could be called positively outrageous service.  “FUN” is the company’s mandate!  Leading the way is founder and CEO, Herb Kelleher.  “Herb Kelleher is definitely the zaniest CEO in the world,” Libby Sartain, vice president of Southwest Airlines’ People Department, admits.  “Where else would you find a CEO who dresses up as Elvis Presley, who’s on a first-name basis with 20,000 employees, and who has a heart as big as the state of Texas?  His style has fostered an atmosphere where people feel comfortable being themselves, where they can have a good time when they work.”

Legendary for his love of laughter, Kelleher calls his unique leadership style management by fooling around.  “An important part of leadership, I think, is enjoying what you’re doing and letting it show to the people that you work with,” Kelleher reveals.  “And I would much rather have a company that is bound by love, rather than bound by fear.”  Kelleher’s philosophy has been enthusiastically embraced by a workforce that is 85 percent unionized.  “Southwest’s culture is designed to promote high spirit and avoid complacency.  We have little hierarchy here.  Our employees are encouraged to be creative and innovative, to break rules when they need to in order to provide good service to our customers,” Sartain explains.  “If you create the type of environment that a person really feels valued and they feel they make a difference, then they’re going to be motivated.  That’s the type of environment we create here for our employees,” Rita Bailey, Southwest’s director of training, adds.

Beginning with its new-employee orientation, the airline nurtures entrepreneurship by grooming a workforce of leaders.  “You can do whatever it takes to keep this airline on top,” an orientation instructor tells his class of newly hired staffers.  At Southwest Airlines’ University for People, future managers and supervisors attend a course titled “Leading with Integrity.”  Through a series of role-playing exercises, employees learn that trust, cooperation, mutual respect, and good communication are the components of success.  “An organization that has an esprit, that does things cooperatively and voluntarily rather than through coercion, is the most competitive organization you can have,” Kelleher asserts.  These guiding principles have earned Southwest Airlines the distinction of being named one of the ten best companies to work for in America.

Employees are valued and recognized in many ways for their achievements.  Perhaps the most prestigious is Southwest’s “Heroes of the Heart” award.  Each year, one outstanding department has its name tattooed on a Southwest Jet.  Southwest was the first airline to offer stock options to its employees.  Today, employees own approximately 10 percent of the company.

In the lobby of Southwest Airlines’ corporate headquarters is a prominent tribute to the men and women of Southwest.  It reads, “The people of Southwest Airlines are the creators of what we have become—and what we will be.  Our people transformed an idea into a legend.  That legend will continue to grow only so long as it is nourished by our people’s indomitable spirit, boundless energy, immense goodwill, and burning desire to excel.  Our thanks and our love to the people of Southwest Airlines for creating a marvelous family and wondrous airline.”

1.    Describe some of the factors needed to reengineer corporate thinking that Southwest Airlines already exhibits.  Compare and contrast these factors to those that other businesses must study and analyze.  Do case outcomes help other businesses to make good decisions?

2.    What specific elements of a corporate entrepreneurial strategy are apparent within Southwest Airlines?  How can a small business owner learn from this and apply the information and outcomes to his or her own company?

3.    Has Herb Kelleher structured a climate conducive to entrepreneurial activity?  Why or why not?  Has this changed over time?  Support your answer.

Decide on your area of research and find recent literature in this area.

•Write notes on critical review of literature.

•What do you understand by referencing and what are its different styles?

Hazard Analysis and Risk Assessment Project

Be sure to read all of the instructions. There are two documents to be prepared and submitted.

1. Following steps 1-11 of the Hazard Analysis and Risk Assessment Guide in the course textbook (pp. 171-174),

develop a risk assessment for a serious workplace hazard with which you are familiar, or use Addendum D to

Chapter 11 (pp. 202-206) to help you select a hazard. Evaluate the hazard and its associated risks, and then

complete the Hazard Analysis and Risk Analysis Project form (click here to access this form). To complete the

Initial Risk Assessment and Post Control Risk Assessment sections, use the following codes based on the Risk

Assessment Matrix in Table 11.10 (p.180) of the textbook:

SEVERITY:

1 – Catastrophic

2 – Critical

3 – Marginal

4 – Negligible

PROBABILITY (Likelihood of Occurrence):

A – Frequent

B – Probable

C – Occasional

D – Remote

E – Improbable

RISK CODE:

H – High

S – Serious

M – Medium

L – Low

All sections of the form must be completed. Note that the “Post Control Risk Assessment Measures” section

reflects the risk assessment AFTER applying the additional control measures.

2. In a separate document of at least 500 words, explain the reasoning behind how you filled out each section of the

form. Use references as needed to support the discussion.

Upload both the completed form and the discussion document. Be sure that the discussion document is in APA format

with a title page and a reference page.

Open a new data file in SPSS. You will create a file containing 1 variable for each item (question) on the survey (for a total of 10). You will score each individual survey and enter the values into the appropriate column of the SPSS data file for later analysis.

Write a 700- to 1,050-word paper in which you include the following information below. Use headings consistent with the APA format for each bullet point below so that your paper is easy to follow and understand. The Center for Writing Excellence has information about using the APA format and a sample paper you can review.
Explain your current fitness and nutritional habits.
Explain some of the health risks associated with obesity.
Identify and describe three new fitness habits you could reasonably incorporate into your lifestyle. How could these new habits improve your health?
Identify and describe three new nutritional habits you could reasonably incorporate into your lifestyle. How might these habits improve your health?
Discuss how each new habit would promote healthy weight management.
Discuss how each new habit would benefit your health in general.
Cite at least three peer-reviewed scientific references. The references and in-text citations must be in APA format.

Format your paper consistent with APA guidelines.

For this assignment, you will use Martin Luther King’s ” I Have a Dream” speech to help you practice the important rhetorical skill of paraphrasing. Be sure to address the following:

• Create a thesis according to this model: In his “I Have a Dream” speech, Martin Luther King uses the strategy of ______ to _________, ________ and ________. Be sure to paraphrase the speech throughout your analysis.
• Describe one strategy for development of the speech that you can identify with or you think is effective from Chapter 13 and the Connect activities you participated in.
• Explain why you think the strategy is effectively used in the speech.
• Incorporate at least one quote from the speech and properly cite the quote on the References page.
• Explain how you plan to use the development strategy in your Portfolio Project.

Requirements:

• Your written paper should be 2-3 pages in length not counting the required title and reference pages.
• You must accurately insert a quote in your analysis to provide in-text evidence from the essay or article you selected, and you must comment on the quote to demonstrate you are thinking in a critical manner.
• Your paper must be formatted according to CSU-Global Guide to Writing and APA Requirements.

Develop a 6- to 8-slide Microsoft^® PowerPoint^® presentation, with notes, in which you relate consumer behavior and social media influence.

Address the following:

• Define consumer behavior, and how it relates to marketing.
• Select a recent purchase and describe how social media and word of mouth influenced your decision. Samsung Galaxy Note 4
• Provide examples of social media in your decision, such as screen shots or video.
• Cite the assigned reading and at least one outside reference.

Format your presentation consistent with APA guidelines.