Which type of table relationship should you use?

HOTSPOT

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.

View Answer

Answer:

Explanation:

Box 1: One-to-many relationship

Each educator can have 0, 1, or many qualifications

Box 2: One-to-many relationship

Each educator can be the primary educator for 0, 1 or many cources.

Box 3: Many-to-many relationship that uses a custom table.

Note: N:N (Many-to-Many): A table relationship that depends on a special Relationship table, sometimes called an Intersect table, so that many rows of one table can be related to many rows of another table.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships