Part 1:

A. Design and populate a Pricing table that includes basic training rate information. Designate the "Technical" field type as "Yes/No" (Boolean).(hint: create & populate Pricing Table).

B. 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). (hint: create & populate Course Table).

C. Prepare a query that lists each course name and its duration (hint: use the Course Table only).

D. Prepare a query that lists each course name and its cost/price per day of training (hint: you need first to link the two tables (Pricing Table and Courses Table) by "Technical" field to generate this query).

Part 2:

A. Add a Class Schedule table to your training database. Designate the ScheduleID field as a "Primary Key" and allow your database program to automatically generate a value for this field.

Make the CourseID field a number field and the StartDate field a date field. (hint: create & populate Class Schedule Table).

B. Add a Class Roster table to your training database. Make ScheduleID field a number field. Make the Reminder and Confirmed fields both "yes/no" (Boolean) fields. (hint: create & populate Class Roster Table).

C. Prepare a query that lists the participants who are only confirmed (hint: you need to use Class Roster Table and have "Yes" for Confirmed).

D. Generate a report that lists Course Name, Location, Start Day, and Price Per Day (hint: use two tables (Course Table and Class Schedule)).