Solve it based on management Information system $>$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

supervis or measures your effectiveness in part according to the average cost per training hour

and type of training. In short, your supervis or 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 CourseID 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.