Can u solve question 2 the first question has already been answered here

i only need solution for question 2 training cost management. thank you

1. Hotel W C Medical the de relating de Analysis Exercises Geetheg h appy by w IDC wy wwwing the merger i ghed reproduced in the pricing these dades highest e Schedule will show they filtry D key G 222/711 - Price per ty Mahe 212 . Cand the Christe Welce the paren the red for a while the Che Schedule 101- 1033083.144 bep Sapped the OLC. the Microwd of what with their det 2. Training Com m ent Having determined the cost per student for each of the classes in the previous problem, you now must carefully manage das 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 ma mum attendance. Your training provider, Hands-On Technology Transfer Ine, requires two weeks' notice in the event that you need to reschedule a dans. You should make sure your classes are at least two-thirds full lefore 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 I to perform the following activities a. Using the information provided in the sample below discourse schedule table to your training data base Designate the Scheduled field as a "Primary Key and allow your database program to generate a value for this field automatically. Make the Counsel field a number field and the Standate field a date fickel. b. Using the information provided in the sample below dadass roster table to your training database Make the Scheduled field a number field. Make the Reminder and Confirmed fields both Yes/No" (Boolean)fiel 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 participants name and e-mail address in the Class Renter tale? What other database design might you use to recond this information? e. Write a query that shows how many people have registered for each scheduled class. Include the class name, capacity, dlate, and cont of attendees Class Schedule Schedule Price per Day Course ID 1 1 Location 101- 7 101-A 101-B 101-A&B 101-A...B Start Date /12/2008 7/19/2008 7/19/2008 7262008 8/2/2008 52.680 52.680 $2.680 $2.144 $2,144 Confirmed Class Roster Schedule ID Participant e-mail Reminder Linda adams1@.. Yes Adams Fatima ahmad.re... Yes Ahmad Adam Alla alba Yes Denys Alyes alyale... No Kathy Barabarake. Yes No2 Problem Training Cost Management Part 1 Joining Tables You have the responsibility for managing technical training classes within your organization. These classes fall under 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 based upon 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 Inc. (HOTT) (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 the data below, design and populate a table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean). b. Using the data below, design your organization. a. Using the data below, design and populate a table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean). b. Using the data below, design and populate a course table. Designate the Courseld 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. PRICING TABLE Technical Price Per Day Capacity Yes 2680 15 PRICING TABLE Technical Price Per Day Capacity 2680 15 No 2144 30 Yes COURSE TABLE Course Course Name Duration Technical ID 5 Yes Yes ASP Programming XML Programming PHP Programming Microsoft Word Advanced Microsoft Excel - Advanced Yes .5 No 5 .5 | No 2. Training Com m ent Having determined the cost per student for each of the classes in the previous problem, you now must carefully manage dass 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 ma mum attendance. Your training provider, Hands-On Technology Transfer Ine, requires two weeks' notice in the event that you need to reschedule adass. You should make sure your classes are at least two-thirds full lefore 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 I to perform the following activities a. Using the information provided in the sample below discourse schedule table to your training data base Designate the Scheduled field as a "Primary Key and allow your database program to generate a value for this field automatically. Make the Counsel field a number field and the Standate field a date fick b. Using the information provided in the sample below, d ass roster table to your training database Make the Scheduled 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 participants name and e-mail address in the Class Renter tale? What other database design might you use to recond this information? e. Write a query that shows how many people have registered for each scheduled class. Include the class name, capacity, dlate, and cont of attendees Class Schedule Schedule Price per Day Course ID 1 1 Location 101- 7 101-A 101-B 101-A&B 101-A...B Start Date /12/2008 7/19/2008 7/19/2008 7262008 8/2/2008 52.680 52.680 $2.680 $2.144 $2,144 Confirmed Class Roster Schedule ID Participant e-mail Reminder Linda adams1@.. Yes Adams Fatima ahmad.re... Yes Ahmad Adam Alla alba Yes Denys Alyes alyale... No Kathy Barabarake. Yes No2 1. Hotel W C Medical the de relating de Analysis Exercises Geetheg h appy by w IDC wy wwwing the merger i ghed reproduced in the pricing these dades highest e Schedule will show they filtry D key G 222/711 - Price per ty Mahe 212 . Cand the Christe Welce the paren the red for a while the Che Schedule 101- 1033083.144 bep Sapped the OLC. the Microwd of what with their det 2. Training Com m ent Having determined the cost per student for each of the classes in the previous problem, you now must carefully manage das 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 ma mum attendance. Your training provider, Hands-On Technology Transfer Ine, requires two weeks' notice in the event that you need to reschedule a dans. You should make sure your classes are at least two-thirds full lefore 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 I to perform the following activities a. Using the information provided in the sample below discourse schedule table to your training data base Designate the Scheduled field as a "Primary Key and allow your database program to generate a value for this field automatically. Make the Counsel field a number field and the Standate field a date fickel. b. Using the information provided in the sample below dadass roster table to your training database Make the Scheduled field a number field. Make the Reminder and Confirmed fields both Yes/No" (Boolean)fiel 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 participants name and e-mail address in the Class Renter tale? What other database design might you use to recond this information? e. Write a query that shows how many people have registered for each scheduled class. Include the class name, capacity, dlate, and cont of attendees Class Schedule Schedule Price per Day Course ID 1 1 Location 101- 7 101-A 101-B 101-A&B 101-A...B Start Date /12/2008 7/19/2008 7/19/2008 7262008 8/2/2008 52.680 52.680 $2.680 $2.144 $2,144 Confirmed Class Roster Schedule ID Participant e-mail Reminder Linda adams1@.. Yes Adams Fatima ahmad.re... Yes Ahmad Adam Alla alba Yes Denys Alyes alyale... No Kathy Barabarake. Yes No2 Problem Training Cost Management Part 1 Joining Tables You have the responsibility for managing technical training classes within your organization. These classes fall under 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 based upon 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 Inc. (HOTT) (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 the data below, design and populate a table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean). b. Using the data below, design your organization. a. Using the data below, design and populate a table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean). b. Using the data below, design and populate a course table. Designate the Courseld 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. PRICING TABLE Technical Price Per Day Capacity Yes 2680 15 PRICING TABLE Technical Price Per Day Capacity 2680 15 No 2144 30 Yes COURSE TABLE Course Course Name Duration Technical ID 5 Yes Yes ASP Programming XML Programming PHP Programming Microsoft Word Advanced Microsoft Excel - Advanced Yes .5 No 5 .5 | No 2. Training Com m ent Having determined the cost per student for each of the classes in the previous problem, you now must carefully manage dass 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 ma mum attendance. Your training provider, Hands-On Technology Transfer Ine, requires two weeks' notice in the event that you need to reschedule adass. You should make sure your classes are at least two-thirds full lefore 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 I to perform the following activities a. Using the information provided in the sample below discourse schedule table to your training data base Designate the Scheduled field as a "Primary Key and allow your database program to generate a value for this field automatically. Make the Counsel field a number field and the Standate field a date fick b. Using the information provided in the sample below, d ass roster table to your training database Make the Scheduled 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 participants name and e-mail address in the Class Renter tale? What other database design might you use to recond this information? e. Write a query that shows how many people have registered for each scheduled class. Include the class name, capacity, dlate, and cont of attendees Class Schedule Schedule Price per Day Course ID 1 1 Location 101- 7 101-A 101-B 101-A&B 101-A...B Start Date /12/2008 7/19/2008 7/19/2008 7262008 8/2/2008 52.680 52.680 $2.680 $2.144 $2,144 Confirmed Class Roster Schedule ID Participant e-mail Reminder Linda adams1@.. Yes Adams Fatima ahmad.re... Yes Ahmad Adam Alla alba Yes Denys Alyes alyale... No Kathy Barabarake. Yes No2