b. Using the data below, 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.
Technical Price per day capacity
Yes $2,680 15
No $2,144 30
Course table© BrainMass Inc. brainmass.com September 24, 2018, 9:29 pm ad1c9bdddf - https://brainmass.com/computer-science/databases/designing-and-populating-a-table-505548