Re: Relational loops in a DB

Поиск
Список
Период
Сортировка
От Gavin Flower
Тема Re: Relational loops in a DB
Дата
Msg-id 5322505D.4050004@archidevsys.co.nz
обсуждение исходный текст
Ответ на Relational loops in a DB  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Список 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
Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Relational loops in a DB
Следующее
От: Adam Mackler
Дата:
Сообщение: Re: Relational loops in a DB