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)).