Skip site navigation (1) Skip section navigation (2)

A generic question: Schema without foreign key specification?

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: A generic question: Schema without foreign key specification?
Date: 2004-09-16 15:41:05
Message-ID: 20040916154105.69072.qmail@web61207.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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 

In response to

Responses

pgsql-novice by date

Next:From: Sun H ChiDate: 2004-09-16 17:54:37
Subject: connecting to postgresql
Previous:From: Kumar SDate: 2004-09-15 21:56:06
Subject: Re: Populating tables with data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group