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

Identify by name and location the component parts of product

You would need to trace the history of both the metal chain and the diamond back to their origins and forward until the point at which the diamond and chain are combined to

Major function of marketing channels

Compare and contrast the four major types of marketing channels for consumer products. Through which type of channel is each of the following products most likely to be dist

Do you agree or disagree with president obamas statement

What should happen to companies that post inaccurate information? What should happen to individuals who post inaccurate information? What should you remember when reading or

Explain is given instrument negotiable

The holder of this instrument shall have the election to require the assignment and delivery to him of my 100 shares of Brookside Iron Works Corporation stock in lieu of the

Performance possible from the resources

1. Why is it important to identify and schedule resources correctly early rather than later? 2. What are some of the best practices you would use if faced with situations wher

Explain and critically evaluate what pfizer is doing

Describe and critically evaluate what Pfizer is doing and discuss the concepts of organizational structure and critically analyze the structural implications (in terms of dim

How has beta transferred the check

Beta delivers the check to Gamma without indorsing it in exchange for one hundred shares of General Motors stock owned by Gamma. How has Beta transferred the check? What rig

Examine the key traits and characteristics

Examine the key traits and characteristics that transformational leaders possess. Predict the impact that a transformational leader's response to a failure would have on per

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