| From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Relational loops in a DB |
| Date: | 2014-03-14 00:42:05 |
| Message-ID: | 5322505D.4050004@archidevsys.co.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 14/03/14 13:18, JORGE MALDONADO wrote:
> 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
>
>
>
>
>
I've attached my suggestion, change details to suite - if you find it
useful.
Cheers,
Gavin
| Attachment | Content-Type | Size |
|---|---|---|
| course-20140314a.jpg | image/jpeg | 262.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Mackler | 2014-03-14 14:11:29 | Re: Relational loops in a DB |
| Previous Message | David Johnston | 2014-03-14 00:37:25 | Re: Relational loops in a DB |
