Relational loops in a DB

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

Responses

Browse pgsql-novice by date

  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