Postgres Pro
Downloads
Home   >   mailing lists

Relational loops in a DB - Mailing list pgsql-novice

From JORGE MALDONADO
Subject Relational loops in a DB
Date
Msg-id CAAY=A7-RiQ5qBCgmqLaHwiaYkhSijQOgx4Wvzq7FuTBBAcO+Lg@mail.gmail.com
Whole thread Raw
Responses Re: Relational loops in a DB  (David Johnston <polobo@yahoo.com>)
Re: Relational loops in a DB  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Relational loops in a DB  (Adam Mackler <postgresql@mackler.org>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Steven Schlansker
Date:
Subject: Re: [JDBC] Cannot insert to 'path' field using EclipseLink
Next
From: David Johnston
Date:
Subject: Re: Relational loops in a DB