Managing technical training classes within your organization

Assignment Help Management Theories
Reference no: EM131052804

Joining Tables

You have the responsibility for managing technical training classes within your organization. These classes fall into two general types: highly technical training and end-user training. Software engineers sign up for the former and administrative staff sign up for the latter. Your supervisor measures your effectiveness in part according to the average cost per training hour and type of training. In short, your supervisor expects the best training for the least cost. To meet this need, you have negotiated an exclusive on-site training contract with Hands-On Technology Transfer (HOTT) Inc.( www.traininghott.com), a high quality technical training provider. Your negotiated rates are reproduced below in the pricing table. A separate table contains a sample list of courses you routinely make available for your organization.

a. Using these data, design and populate a table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean).

b. Using these data, design and populate a course table. Designate the Course ID field as a "Primary Key" and allow your database to automatically generate a value for this field. Designate the "Technical" field type as "Yes/No" (Boolean).

c. Prepare a query that lists each course name and its cost per day of training. d. Prepare a query that lists the cost per student for each class. Assume maximum capacity and that you will schedule two half-day classes on the same day to take full advantage of HOTT's per-day pricing schedule.

 

Reference no: EM131052804

Questions Cloud

Certificate indicates that the stated coupon rate for bond : A Company has a bond outstanding with a face value of $10000 that reaches maturity in 10 years. The bond certificate indicates that the stated coupon rate for this bond is 0.08% and that the coupon payments are to be made semiannually. Assuming the a..
Factors influencing online consumer shopping behaviour : Online shopping In India - A study of factors influencing online consumer shopping behaviour.
Describe the ideal learning environment for you : How did the teacher in your selected movie display characteristics of a humanistic teacher? Be specific by providing examples and connecting your response to the text.
Money stays extremely liquid : Robert and Cora might receive a settlement in the amount of $800,000. Robert and Cora want to know how to make sure their money is protected from a bank failure and that the money stays extremely liquid. Please help educate Robert and Cora on the FDI..
Managing technical training classes within your organization : You have the responsibility for managing technical training classes within your organization. These classes fall into two general types: highly technical training and end-user training. Software engineers sign up for the former and administrative ..
Hofstede five dimensions of culture : Review the information provided on Hofstede's Five Dimensions of Culture in this week's lecture. Choose two countries to compare using Hofstede's Five Dimensions of Culture.
Application that prompts for and reads a double value : Write an application that prompts for and reads a double value representing a monetary amount.
Calculate the debt equity ratio using the debt asset ratio : The review covers debt asset ratio as an example of how to calculate ratios and that is different from debt equity ratio, and that is different from the debt equity ratio so think about how you calculate the debt equity ratio using the debt asset ..
Provide broader set of information about company performance : You are required to research information on the below issues, and then write the results of your research in an essay format - The main criticisms of traditional financial reporting and What other types of information could be included in annual repo..

Reviews

Write a Review

Management Theories Questions & Answers

  Research and compare behavior assessment instruments

Research and compare behavior assessment instruments available on the market today.

  Each page will evaluate one of your smart goals

Each page will evaluate one of your SMART goals.

  Consider the global sourcing lessons multinationals need to

consider the global sourcing lessons multinationals need to learn from the experiences of other companies such as ikea

  Making information systems investments

Making Information Systems Investments. Using the Case Study Template format found in Doc Sharing, submit your assessment of three projects that need to be implemented immediately at the Clarion School and how you would prioritize those projects.

  Course-business research for decision making

This week chat was very interesting, makes me think of how careful we all have to be when doing research on our IP, the term "provenance" and "questionable Provenance, was the discussion. so when I do my project I will be very careful where i get ..

  What is the definition of culture

What is the definition of culture?

  Difference between asset management and fm

1. The owner/manager of the assets will ask what is the difference between Asset management and FM? How will you answer the owner? The deliverable will be a brief answer to the question bearing in mind the type of assets FM will manage.

  Werhane and radin contend that employment

Werhane and Radin contend that Employment At Will is violations of the respect employees are due as persons

  Codification provide concerning reporting inventories

Due to rising fuel costs costs , your client,overstock.com is considering adding a charge for shipping and handling costs on products sold through its website . What it is the authortatve guidance for reporting these costs?

  Dynamic pricing unit

Dynamic pricing unit

  What is the probability that a blue chip will be drawn

The probability of drawing a pink chip from a bowl of different colored chips is 0.35, the probability of drawing a blue chip is 0.46, the probability of drawing a green chip is 0.15, and the probability of drawing a purple chip is 0.04. What is ..

  Thomas lennon, actor and entrepreneur

Although comedy may look like all fun and games, making movies in Hollywood is serious business. Few people understand this as well as Thomas Lennon. Although best known for his starring role in the Comedy Central series Reno 911, Lennon does his ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd