Training-cost management

Assignment Help Management Theories
Reference no: EM131052809

Training-Cost Management

Having determined the cost per student for each of the classes in the previous problem, you now must carefully manage class registration. Because you pay the same flat rates no matter how many students attend (up to capacity), you want to do all you can to ensure maximum attendance. Your training provider, Hands-On Technology Transfer Inc., requires two weeks' notice in the event that you need to reschedule a class. You should make sure your classes are at least two-thirds full before this deadline. You should also make sure you send timely reminders to all attendees so that they do not forget to show up. Use the database you created in Problem 1 to perform the following activities:

a. Using the information provided in the sample below, add a course schedule table to your training database. Designate the Schedule ID field as a "Primary Key" and allow your database program to generate a value for this field automatically. Make the Course ID field a number field and the Start Date field a date field.

b. Using the information provided in the sample below, add a class roster table to your training database. Make the Schedule ID field a number field. Make the Reminder and Confirmed fields both "Yes/No" (Boolean) fields.

c. Because the Class Schedule table relates to the Course Table and the Course Table relates to the Pricing Table, why is it appropriate to record the Price per Day information in the Class Schedule table too?

d. What are the advantages and disadvantages of using the participant's name and e-mail address in the Class Roster table? What other database design might you use to record this information?

e. Write a query that shows how many people have registered for each scheduled class. Include the class name, capacity, date, and count of attendees.

Reference no: EM131052809

Work breakdown structure requires costing data

During the initial pricing activities, one of the functional managers discovers that the work breakdown structure requires costing data at a level that is not normally made,

A list of assets provided by the advertising

Video Question To watch this chapter's video, Accountant's Liability, go to www.cengagebrain.com. Register the access code that came with your new book or log in to your exi

What are rights of ray and upson in event of breach

Ray (signed) Shaw On August 26 Ray informs Shaw and Todd that the contract was in reality signed by him as agent for Upson. What are the rights of Ray, Shaw, Todd, and Upson

Corporate charter for purpose of conducting retail business

They operated the business for three years, after which time it became insolvent. The creditors desire to hold the members personally and individually liable. May they do so

Amount of irish cash flow from assets

Irish Towing has sales of $543,449, COGS and SG&A totaling $185,731, depreciation expense of $67,587, and taxes paid of $80,400. A partial listing of its balance sheet accou

Rutter nursery company packages

Rutter Nursery Company packages its pine bark mulch in 50-pound bags. From a long history, the production department reports that the distribution of the bag weights follows

Explain who will prevail

Barta, therefore, could not obtain a leasing agreement meeting his approval. Barta refused to close the sale. In a suit by K&K Pharmacy against Barta for breach of contract,

Explain the general purposes of the management report

Explain the general purposes of the management report included in the annual report to shareholders. Identify five subject areas or topics that have been recommended for inclu

Reviews

Write a Review

 
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