A generic question: Schema without foreign key specification?

Поиск
Список
Период
Сортировка
От Kumar S
Тема A generic question: Schema without foreign key specification?
Дата
Msg-id 20040916154105.69072.qmail@web61207.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: beta2 or cvs?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: A generic question: Schema without foreign key specification?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-novice
Dear group,
 While designing 3-4 different schemas for my
database, a question has been chasing me. I am not a
CS graduate and I was never taught the nitty gritty's
of Dabase schema or rules.

My question is - a schema that has no foreign key
defined (except in 1 or 2 instances), will it be
considered a good schema or bad schema by experts.

Imagine a scenario where most of the relations are
defined by linker tables(relationship table) that is
formed by two different primary keys from two
different tables are defined to avoid foreign key
relationships. creating a database in this kind of
scenario, can it be considered a good database design.


I hope it is not a stupid question. If it is please
excuse my ignorance.

Thanks
Kumar.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Предыдущее
От: Jake Stride
Дата:
Сообщение: Re: is there a sql command to display table definition?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: A generic question: Schema without foreign key specification?