Describe your experiences related to your setup of MySQL

Install EasyPHP and MySQL and take a screen shot that shows the MySQL prompt on your screen. (Note: You must include the screen shot which shows that MySQL is installed on your computer as part of your assignment. An installation guide to aid the installation of EasyPHP and MySQL is located here.

  • Research the capabilities of MySQL.

Write a one to two (1-2) page paper in which you:

  1. Describe your experiences related to your setup of MySQL. Include any difficulties or issues that you had encountered during the installation.
  2. Based on your post-installation research, describe the main capabilities of MySQL.
  3. Describe the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Determine the additional information that you will need to implement the database design in a database management system.
  4. Include the screen shot which shows that MySQL is installed on your computer.

Which of the following is an example of reverse discrimination?

1. _____ is a method of promoting safety by determining which specific element of a job led to a past accident.

value:
1.00 points
Cost-benefit analysis
Utilization analysis technique
Technic of operations review
Conjoint analysis technique
Job hazard analysis technique
2. _____ forbids discrimination based on race, color, religion, sex, or national origin and is enforced by the EEOC.

value:
1.00 points
Title VII of the Civil Rights Act
The Civil Rights Act of 1991
The Fourteenth Amendment
Executive Order 11246
The Rehabilitation Act of 1973
3. Reasonable accommodation refers to:
value:
1.00 points
an employer’s obligation to provide comfortable lodging near the work place for all employees.
an employer’s obligation to provide reasonable and safe working conditions to the employees.
an employer’s obligation to do something to enable an otherwise qualified person to perform a job.
an employer’s obligation to compensate the employees for the increasing living expenses.
an employer’s obligation to accommodate a laid off employee when there is a vacancy.
4. Which of the following recruitment scenarios provide evidence of discrimination according to the four-fifths rule?
value:
1.00 points
Out of 50 applicants (25 black and 25 white), 4 blacks and 5 whites were recruited.
Out of 75 applicants (15 black and 60 white), 3 blacks and 12 whites were recruited.
Out of 300 applicants (140 black and 160 white), 12 blacks and 10 whites were recruited.
Out of 500 applicants (300 black and 200 white), 20 blacks and 20 whites were recruited.
Out of 200 applicants (140 black and 60 white), 22 blacks and 11 whites were recruited.
5. The management of Carlson Meyer Consulting believes that married women with children are more likely to remain absent from work when compared to their unmarried or childless counterparts. As such, there is an unwritten policy at Carlson Meyer for preferably hiring married men over married women with children. This is an example of _____.
value:
1.00 points
reverse discrimination
disparate treatment
the four-fifths rule
a bona fide occupational qualification
an affirmative action
6. _____ are forms that the OSHA has made mandatory to inform employees about the hazards associated with the use of certain chemicals.
value:
1.00 points
Chemical information sheets
Safety fact sheets
Hazardous substance information sheets
Chemical data sheets
Material safety data sheets
7. Which of the following is an example of reverse discrimination?
value:
1.00 points
Discrimination against white men in the U.S.
Discrimination against women in the U.S.
Discrimination against black men in the U.S.
Discrimination against minorities in the U.S.
Discrimination against black women in the U.S.
8. Businesses with federal government contracts for more than $50,000 are required to have a written affirmative action plan on file. Which of the following is a basic component of such a plan?
value:
1.00 points
Cost-benefit analysis
Refresher programs
EEOC programs
Conjoint analysis
Utilization analysis
9. Which of the following is the last major component of an OSHA inspection which involves the compliance officer sharing his findings with the employer?
value:
1.00 points
A technic of operations review.
A closing conference.
An inspection following a notification.
A job hazard analysis.
A safety awareness program.
10. Which of the following is primarily responsible for enforcing the human resource laws passed in the United States?
value:
1.00 points
The Cabinet.
The legislative branch of the government.
The judicial branch of the government.
The Congress.
The executive branch of the government.
11. Which of the following is true about the Fourteenth Amendment to the U.S. constitution?
value:
1.00 points
It abolished slavery in the United States.
It required that men and women performing equal jobs receive equal pay.
It mandated affirmative action in the employment of individuals with disabilities.
It granted all citizens the right to make, perform, modify, and terminate contracts.
It provided equal protection for all citizens and requires due process in state action.
12. Under the _____, OSHA is responsible for inspecting employers, applying safety and health standards, and levying fines for violation.
value:
1.00 points
Department of Health
Department of Labor
Department of Development
Department of Human Services
Department of Commerce
13. Below are the ratios for the hiring rates of blacks to the hiring rates of whites. Which provides evidence of adverse impact?
rev: 11_28_2015_QC_CS-34818, 12_10_2015_CS-35239
value:
1.00 points
0.71
1.23
1.34
0.86
0.98
14. _____ is a condition in which employment practices are seemingly neutral yet disproportionately exclude a protected group from employment opportunities.
value:
1.00 points
Affirmative action
Bona fide occupational qualification
The four-fifths rule
Disparate impact
Reverse discrimination
15. The EEOC defines sexual harassment of employees as unlawful employment discrimination based on _____.
value:
1.00 points
the Equal Opportunities Act
the Fourteenth Amendment
the Rehabilitation Act of 1973
Executive Order 11246
Title VII of the Civil Rights Act

 

 

Manufacturing Company’s Budgetary Control System Analysis

Tom Emory and Jim Morris strolled back to their plant from the administrative offices of Ferguson & Son Manufacturing Company. Tom is manager of the machine shop in the company’s factory; Jim is manager of the equipment maintenance department.

The men had just attended the monthly performance evaluation meeting for plant department heads. These meetings had been held on the third Tuesday of each month since Robert Ferguson, Jr., the president’s son, had become plant manager a year earlier.

As they were walking, Tom Emory spoke: “Boy, I hate those meetings! I never know whether my department’s accounting reports will show good or bad performance. I’m beginning to expect the worst. If the accountants say I saved the company a dollar, I’m called ‘Sir,’ but if I spend even a little too much—boy, do I get in trouble. I don’t know if I can hold on until I retire.”

Tom had just been given the worst evaluation he had ever received in his long career with Ferguson & Son. He was the most respected of the experienced machinists in the company. He had been with the company for many years and was promoted to supervisor of the machine shop when the company expanded and moved to its present location. The president (Robert Ferguson, Sr.) had often stated that the company’s success was due to the high-quality work of machinists like Tom. As supervisor, Tom stressed the importance of craftsmanship and told his workers that he wanted no sloppy work coming from his department.

When Robert Ferguson, Jr., became the plant manager, he directed that monthly performance comparisons be made between actual and budgeted costs for each department. The departmental budgets were intended to encourage the supervisors to reduce inefficiencies and to seek cost reduction opportunities. The company controller was instructed to have his staff “tighten” the budget slightly whenever a department attained its budget in a given month; this was done to reinforce the plant manager’s desire to reduce costs. The young plant manager often stressed the importance of continued progress toward attaining the budget; he also made it known that he kept a file of these performance reports for future reference when he succeeded his father.

Tom Emory’s conversation with Jim Morris continued as follows:

Emory: I really don’t understand. We’ve worked so hard to meet the budget, and the minute we do so they tighten it on us. We can’t work any faster and still maintain quality. I think my men are ready to quit trying. Besides, those reports don’t tell the whole story. We always seem to be interrupting the big jobs for all those small rush orders. All that setup and machine adjustment time is killing us. And quite frankly, Jim, you were no help. When our hydraulic press broke down last month, your people were nowhere to be found. We had to take it apart ourselves and got stuck with all that idle time.

Morris: I’m sorry about that, Tom, but you know my department has had trouble making budget, too. We were running well behind at the time of that problem, and if we had spent a day on that old machine, we would never have made it up. Instead, we made the scheduled inspections of the forklift trucks because we knew we could do those in less than the budgeted time.

Emory: Well, Jim, at least you have some options. I’m locked into what the scheduling department assigns to me and you know they’re being harassed by sales for those special orders. Incidentally, why didn’t your report show all the supplies you guys wasted last month when you were working in Bill’s department?

Morris: We’re not out of the woods on that deal yet. We charged the maximum we could to other work and haven’t even reported some of it yet.

Emory: Well, I’m glad you have a way of getting out of the pressure. The accountants seem to know everything that’s happening in my department, sometimes even before I do. I thought all that budget and accounting stuff was supposed to help, but it just gets me into trouble. It’s all a big pain. I’m trying to put out quality work; they’re trying to save pennies.

Review the case. Respond to the following:

  • Identify the problems that appear to exist in Ferguson & Son Manufacturing Company’s budgetary control system and explain how the problems are likely to reduce the effectiveness of the system. (approximately 1 page)
  • Explain how Ferguson & Son Manufacturing Company’s budgetary control system could be revised to improve its effectiveness. (approximately 1–2 pages)
  • Explain how the use of an activity-based costing system could change the results of the budget, if utilized. (approximately 1 page)
  • As stated in the case, many employees have “quit trying” and have altered behavior on the job. Provide specific ways for how you would use a budget to change employee behavior and align goals in the organization. Explain how goal alignment can improve profitability and overall return to the shareholders of the company. (approximately 1 page)
  • Synthesize data to explain the concept of ROI and describe how the use of an activity-based costing system can improve the company’s ROI and the potential impact on free cash flow. (approximately 1 page)

Write a 5–6-page report in Word format. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M5_A2.doc.

By Wednesday, November 16, 2016, deliver your assignment to the M5: Assignment 2 Dropbox.

Assignment 2 Grading Criteria
Maximum Points
Identified the problems that appear to exist in the company’s budgetary control system and explained how the problems are likely to reduce the effectiveness of the system.
64
Explained how the company’s budgetary control system could be revised to improve its effectiveness.
64
Explained how the use of an activity-based costing system could change the results of the budget if utilized.
44
Identified ways of how one can use a budget to change employee behavior and align goals in the organization and explained how goal alignment can improve profitability and overall return to shareholders of the company.
44
Synthesized data to explain the concept of ROI, how the use of an activity-based costing system can improve the company’s ROI, and the potential impact on free cash flow.
56
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; and displayed accurate spelling, grammar, and punctuation.
28
Total:
300

Create a query that includes students’ first names, last names, and phone numbers.

Lab 4: Structured Query Language (SQL)

Due Week 7 and worth 75 points

Refer to the database design crested in Lab 2: Modifying a Database Design in Visio to complete this Lab.

Perform the following steps in MySQL:

  1. Create the tables and relationships from the database design discussed in Lab 2.
  2. Add at least five (5) records into each table (Note: You must determine the field values).
  3. Create a query with all fields from the student table, where the student’s last name is “Smith”.
  4. Create a query that includes students’ first names, last names, and phone numbers.
  5. Create a query that includes instructors’ first names, last names, and courses they teach.

Include the following screen shots in a Microsoft Word document to show the completion of the steps above:

  • Screen shot depicting the tables created within MySQL.
  • Screen shots depicting the records added into each table.
  • Screen shots depicting the SQL code and the query results from each of the queries created.

Your assignment must follow these formatting requirements:

  • Submit the lab as a Microsoft Word document.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required assignment page length.