I am designing a DB and some of the tables have a loop in their relationships. I am attaching an image of such tables.
One "course" can be offered at several dates (course offerings) and also one "course" can be thought by several "qualified trainers". A "course offering" is taught by one "qualified trainer".
I will very much appreciate your feedback. I hope my explanation is clear enough.
Respectfully,
