A generic question: Schema without foreign key specification? - Mailing list pgsql-novice

From Kumar S
Subject A generic question: Schema without foreign key specification?
Date
Msg-id 20040916154105.69072.qmail@web61207.mail.yahoo.com
Whole thread Raw
In response to Re: beta2 or cvs?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: A generic question: Schema without foreign key specification?
List 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 by date:

Previous
From: Jake Stride
Date:
Subject: Re: is there a sql command to display table definition?
Next
From: Josh Berkus
Date:
Subject: Re: A generic question: Schema without foreign key specification?