A company offers continuing education courses for medical professionals. Each time a course is offered, the company tracks that the session has taken place in an Excel workbook.
The company maintains a list of required qualifications for an educator to teach a course. Educator qualifications range from languages spoken to advanced degrees.
The company needs the following custom table relationships defined:
✑ Associate educators with a list of their professional qualifications.
✑ Assign a primary educator to each course that is held.
✑ Collect information about every course that is held.
You need to determine the type of relationship that best fits the requirement.
Which type of table relationship should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Box 1: Many-to-Many relationship that uses a system-generated table
Box 2: One-to-Many relationship
Box 3: Many-to-many relationship that uses a custom table.