Joining Tables and Training Cost Management
To accomplish analysis exercise 1 and 2, we have to create tables, query and reports in Microsoft Access. In the Exercises, we are asked to create tables and declare the field types. We have to create Course ID and Schedule ID as a primary key. In the joining table problem, we have to create a query that lists each course name and its cost per day of training, cost per students for each class. Likewise, in the training cost management problem, we have to create number of people who have registered for each scheduled class.
The analysis exercise wants to prepare table for pricing, course, course, and class roster. In the table required field should be included like primary key, Boolean type, date, text. After that prepare a query that list each course name and its cost per day of training and cost per student for each class. For that we have to calculate cost per day; dividing price per day by capacity. After the calculating find the answers for number 2c and 2d.
2c. 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?
In the class schedule table and course table, course Id is related to each other. Therefore, either one is changed another has an impact on it. But, the price per day in pricing table and price per day in class schedule will not be changed because these two tables are not linked directly.
2d. What are the advantages and disadvantages of using the participant’s name and email address in the class roster table? What other database design might you use to record this information?
The advantage of using the participant’s name and email address in the class roster table is to specify the number of students who register for the classes and who didn’t....