A new company is planning to build a new database system for holding information about customers and salesmen. ‘Customers’, ‘Salesmen’ and ‘Customers_Salesmen’ are part of the information that the new company wants to store in the new database. These tables are shown below in figure 1, figure 2 and figure 3. The new company intends to use MySQL for building the new database.

Figure 1: Customers table

Figure 2: Salesmen table

Figure 3: Customers_Salesmen table

Based on the above three tables, answer the following 6 questions:

1. Write an SQL statement for creating the customer table that is shown in figure 2. No need to write any SQL statement for adding any record to the customer table.  
2. Write an SQL statement for adding one record to the customer table that was created in question-1 above. The added record should be one of the records that are given in the customer table.   
3. Write an SQL statement to list the information of salesmen who work in Paris.
4. Write an SQL statement to list all customer names who work with the salesman whose id is 5001.                                                                                                                           \
5. Write an SQL statement to list all customer names who work with the salesman whose commission is 0.13.                                                                                                          ]
6. Write an SQL statement to increase the salesman commission by 5%.

Read/ answer questions below:

Why a Focus on Diversity and Inclusion Is Vital to Health Care Companies

Corporate America is learning that our responsibilities to our stakeholders are multifaceted and interconnected. When we strive for a diverse and inclusive workplace, it benefits everyone — workforce, clients, shareholders, vendors, and communities local and global.

This may be most important in the health care industry, where the workforce needs to be both clinically adept and socially empathetic to serve their increasingly diverse communities.

Focusing on diversity and inclusion is absolutely necessary to access and engage the very best talent available. As everybody should know by now, a company’s workforce is the most critical ingredient in its ability to succeed.

We can’t possibly have the very best team unless we are tapping into the widest and deepest pool of workers available. If any group is not engaged or left out, excellent job candidates with unique experiences and opinions are lost. That means we must be deliberately inclusive to find, hire and retain the top quality workers.

As the leading health care staffing and workforce solutions company, AMN provides a wide variety of health care professionals to clients in all 50 states, from major urban medical centers to home health care companies to rural clinics, while also delivering complex and advanced services ranging from predictive analytics to mid-revenue cycle management. To provide the greatest support to health care organizations, so that they in turn can provide the highest quality patient care, we must have the very best team.

The health care industry we serve is very diverse. Among the overall workforce, 76 percent of people who work at hospitals are women and about 35 percent are black, Asian or Latino, according to the U.S. Bureau of Labor Statistics. The percentage of women in health care is higher than any other industry and our team should reflect the clients we serve.

External stakeholders, like vendors, partners and investors, are looking for value and performance, which are directly dependent on a company building the very best team possible. These stakeholders are also looking for companies that they can be proud of — companies that share their values. Many stakeholders today want to know a company’s diversity numbers up front, to ascertain both the company’s value and its values.

For our team members to do their very best work, they must be engaged. Many women, people of various races and ethnicities, and LGBTQ individuals have been excluded or undervalued in business for a long time.

Inclusion must be an action verb. Diversity and inclusion must be actively interwoven into the fabric of company culture so that all people feel like they belong in the workplace — and that they can succeed there. This effort has to start at the top. It can’t just be a few programs; it must be a fundamental part of the corporate framework.

To be able to track your progression it is important to establish the demographic metrics of your team and regularly check your numbers. Diversity and inclusion are not abstract concepts. They are quantifiable, and a company must keep track to know whether they are making progress.

AMN Healthcare has been striving for gender equality for decades, and more recently has been working harder on other areas of inclusion. In the spirit of transparency, here are the AMN numbers as of April 2018:

- 66 percent of our entire team companywide is women.

- 62 percent of our supervisors and senior managers are women.

- Our executive team includes women as CEO, general counsel, chief clinical officer, chief talent officer, and divisional or brand presidents.

- 34 percent of our entire team is nonwhite.

- Our team is 56 percent Millennials, 34 percent Generation X and 11 percent baby boomers.

We’re pretty proud of our gender diversity. But we know we can improve in other areas. And we need to enhance the culture and spirit of inclusion companywide. So here are some of the things we are doing:

- Talent acquisition strategy for diversity, including metrics on diverse candidate slates.

- Employee resource groups to support a variety of groups and to help the company become a better place for everybody to work.

- Diversity champions and committees.

- Companywide engagement survey that includes questions about diversity and inclusion.

- Unconscious bias training.

- Support for and membership in the Gender Equality Index and Human Rights Campaign Index.

- Increasing diversity among our suppliers.

- Promoting a commitment to diversity externally, particularly in the communities where our team members live.

Diversity and inclusion are the right thing for our team members, our communities and our country. And for our company value and performance. The growing commitment to diversity and inclusion in corporate America is making the workplace a better place.

Answer questions:

1. What key questions or problems does the author raise and why?

2. What information, data, or evidence does the author present to support the purpose of the article?

3. What key conclusion(s) is the author coming to?

4. How is/are the conclusion(s) justified?

Describe, discuss, and give examples of the differences between normal work groups and teams.

Explain each of the following (in your own words):

a. The 3 fundamental rules of subprograms

b. Subprogram

c. Subprogram call

d. Subprogram Header

e. Parameter profile/Protocol

f. Formal Parameter–v-Actual Parameter

g. Procedure –v-Function

h. Design issues for subprograms

i. Stack dynamic –v-static variables

j. Parameter passing

i. In-mode

ii. Out-mode

iii. In-Out mode

1.Pass by result

2.Pass by reference

3.Pass by name

k. Design issues for parameter passing

l. Overloaded subprogram

m. Generic subprogram

n. Design issues for functions

Discuss the primary conditions that foster the development of groupthink. Outline at least four symptoms of a group in which groupthink has taken hold.

Can anyone explain all the answers?

1. A roller coaster car is on a track that forms a circular loop in the vertical plane.  Roller coaster car is moving with constant speed. If the car is to just maintain contact with track at the top of the loop, what is the normal force acting on this car at the lowest point of track?
   1. mg
   2. 2mg
   3. 3mg
   4. 0
2. Bucket of water is rotated on the rope in vertical plane. If the length of a rope is increased twice, to prevent water from spilling on the top point of trajectory, how should we change the minimum speed of rotation?

1. We should increase speed twice
2. We should decrease speed twice.
3. We should increase speed 2^1/2times.
4. We should decrease speed 2^1/2 times.
5. We should not change speed at all.

3. A coin is sitting on the edge of rotating turntables. Compare two turntables, A and B. They have the same radius (it means coin sits at the same distance from a center), but different surfaces. We measure the maximum frequency of revolutions for which coin does not slide off the turntables. For turntable A this frequency as twice as big as for turntable B. We can conclude that coefficient of static friction between coin and turntable A is:

1. ½ of coefficient between coin and turntable B
2. the same as for turntable B
3. twice as big as coefficient between coin and turntable B
4. 2^1/2greater than one for turntable B.
5. 4 times greater than for turntable B

4. The gravitational force attractive force between two masses, is F. If the masses are moved to half of their initial distance, what is the gravitational attractive force?
   1. F/4
   2. F/2
   3. 2F
   4. 4F
5. Two massive objects are fixed in their positions. The third object of mass m is placed between these two at the point where gravitational force due to two massive objects is equal 0. The third object is displaced  slightly towards one of massive objects. The total gravitational force on the third object is now:

1. Zero
2. Directed in the direction which depends on which out of two massive objects has greater mass.
3. Directed in the direction of displacement of the third object
4. Directed in the direction opposite to displacement of the third object.
5. Directed perpendicular to displacement of the third object.

Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:

1.

value:
1.00 points

Required information

Beech’s managers have made the following additional assumptions and estimates:

1. Estimated sales for July, August, September, and October will be $400,000, $420,000, $410,000, and $430,000, respectively.

2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July.

3. Each month’s ending inventory must equal 25% of the cost of next month’s sales. The cost of goods sold is 75% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July.

4. Monthly selling and administrative expenses are always $56,000. Each month $8,000 of this total amount is depreciation expense and the remaining $48,000 relates to expenses that are paid in the month they are incurred.

5. The company does not plan to borrow money or pay or declare dividends during the quarter ended September 30. The company does not plan to issue any common stock or repurchase its own stock during the quarter ended September 30.

Required:

1. Prepare a schedule of expected cash collections for July, August, and September. Also compute total cash collections for the quarter ended September 30.

2-a. Prepare a merchandise purchases budget for July, August, and September. Also compute total merchandise purchases for the quarter ended September 30.

2-b. Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September. Also compute total cash disbursements for merchandise purchases for the quarter ended September 30.

3. Prepare an income statement for the quarter ended September 30.

4. Prepare a balance sheet as of September 30.

Given the following data set N =9

12 3 78 89 22 31 5 20 14

a ) sort the data using: Insertion and Selection sorts

Determine thee number of comparisons and the number of moved for every sort.

b) Sort the data using Heap and bubble sort, show all steps

The lengths of a particular animal's pregnancies are approximately normally distributed, with mean μ equals=271

days and standard deviation σ equals=20days.

(a) What proportion of pregnancies lasts more than 286 days?

(Round to four decimal places as needed.)

(b) What proportion of pregnancies lasts between 256 and 281 days?

(Round to four decimal places as needed.)

(c) What is the probability that a randomly selected pregnancy lasts no more than 266 days?

(Round to four decimal places as needed.)

(d) A "very preterm" baby is one whose gestation period is less than 226 days. Are very preterm babies unusual?

(Round to four decimal places as needed.)

The probability of this event is _____ so it _____ be unusual because the probability is _______ than 0.05.

(Round to four decimal places as needed.)

Argue for and against the trait theory of leadership. give examples.

CarpetPlus sells and installs floor covering for commercial buildings. Brad Sweeney, a CarpetPlus account executive, was just awarded the contract for five jobs. Brad must now assign a CarpetPlus installation crew to each of the five jobs. Because the commission Brad will earn depends on the profit CarpetPlus makes, Brad would like to determine an assignment that will minimize total installation costs. Currently, five installation crews are available for assignment. Each crew is identified by a color code, which aids in tracking of job progress on a large white board. The following table shows the costs (in hundreds of dollars) for each crew to complete each of the five jobs:
   Job

   Crew    1 2 3 4 5

   Red 30 44 38    47 31

   White 25 32 45 44 25

Blue 23 40 37 39 29

   Green 26 38 37    45 28

Brown 26 34    44    43    28

a. Develop a network representation of the problem. b. Formulate and solve a linear programming model to determine the minimum cost assignment

I need EXCEL part in steps. Thank you.

As a business manager, you may encounter situations that require a wide variety of communication responses. For this assessment, you will be creating a portfolio of communication documents. Please appropriately format each communication for the message type.

Scenario 3:

You are a manager of a research company. Your research team has developed a transition package that allows a gas-powered engine to transition to running on biofuels. The availability and low cost of biofuels make the transition package a potential game changer in the automobile market. You have named the product Sparkit.

In addition to tests completed by your staff, you have partnered with a large automobile producer to ensure the transition package works with many different types of vehicles. The large automobile producer remains a partner in the product as a result of their involvement, and you anticipate that future vehicles from the producer may use the technology when initially built. With the producer's assistance, you anticipate 50% of cars currently on the road can potentially be retrofitted with your product. The producer has created a guide for your sales force to ensure that Sparkit is not sold to customers whose cars are not compatible with the product.

This is the first big product developed by your company. Your sales and service teams do not have current relationships with potential buyers. One potential risk is that purchasers may choose to install the transition package on their own rather than choose a knowledgeable automotive professional to install it. You anticipate there may be issues with installation as a result.

The success of Sparkit relies upon an external business partner, Autojor, who manufactures a filter critical to the proper operation of the transition package. As the result of a natural disaster, Autojor recently lost a manufacturing plant that was responsible for producing 25% of your inventory. You will need to work closely with this partner to ensure their manufacturing operation is able to continue supporting the just-in-time environment to meet sales demands. Your contact’s name at Autojor is Mateo Kalani.

You have received a customer complaint via the company’s social media page. The customer is extremely dissatisfied, and the complaint has negatively impacted the company’s image. The customer’s complaint is as follows: “I bought and installed Sparkit. It doesn’t work! The instructions do not match my engine’s layout, and now my car doesn’t work at all. This was supposed to save me money, but now my car won’t run. I’ll have to put more money into getting it fixed. This is ridiculous. I have told all my friends, and now I am telling the world—do not buy this product! If you do, you will regret it.”

Requirements Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. An originality report is provided when you submit your task that can be used as a guide. You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course. Create a portfolio of communication documents based on one of the scenarios by doing the following:

Compose an informational email to external stakeholders (i.e., investors, shareholders) that discusses two distinct organizational and/or financial impacts the product will create.

Compose a persuasive letter to the business partner to discuss their challenges in meeting your production needs.

Evaluate the communication strategies and methods (i.e., email, letter, blog, and social media) used in items A–E by doing the following: Explain how the communication strategies support or do not support the desired outcomes and provide examples to support your conclusion. Explain how the four communication methods effectively or ineffectively serve the target audience and provide examples to support your conclusion.

Acknowledge sources, using APA-formatted in-text citations and references, for content that is quoted, paraphrased, or summarized.

Demonstrate professional communication in the content and presentation of your submission.

1. Apply Durkheim’s view of the functions of deviance to the emerging issue of cyberbullying. How does cyberbullying fulfill each of the functions of deviance that Durkheim discussed?

describe employees retention strategies essay style with work cited?