Relational loops in a DB

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Relational loops in a DB
Дата
Msg-id CAAY=A7-RiQ5qBCgmqLaHwiaYkhSijQOgx4Wvzq7FuTBBAcO+Lg@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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



Вложения

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

Предыдущее
От: Steven Schlansker
Дата:
Сообщение: Re: [JDBC] Cannot insert to 'path' field using EclipseLink
Следующее
От: David Johnston
Дата:
Сообщение: Re: Relational loops in a DB