From: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Relational loops in a DB |
Date: | 2014-03-14 00:18:32 |
Message-ID: | CAAY=A7-RiQ5qBCgmqLaHwiaYkhSijQOgx4Wvzq7FuTBBAcO+Lg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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,
Jorge Maldonado
Attachment | Content-Type | Size |
---|---|---|
![]() |
image/jpeg | 18.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2014-03-14 00:37:25 | Re: Relational loops in a DB |
Previous Message | Rob Sargent | 2014-03-12 18:23:13 | Re: Cannot insert to 'path' field using EclipseLink |