FKs, UKs and PKs

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Wed, 15 Nov 2006 03:57:01 -0800 (PST)
Message-ID: <268522.1180.qm@web34106.mail.mud.yahoo.com>

Hi All,

I've got a quick Data modelling concepts question: Under what circumstances would you create a FK that points to a UK instead of the PK?

I can see how you can sometimes save a table join if the UK data is "meaningful" but the PK is a sequential id. But is this purely a denormalization technique or can such a FK->UK relationship exist in a normalized schema?

Thanks for any comments,
Charlotte  

---

Sponsored Link

Don't quit your job - take classes online www.Classesusa.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 15 2006 - 05:57:01 CST