View Full Version : Relationship Clarification


chris11590
08-18-2008, 10:54 AM
my understanding of one to many relationship is joining a PK table with a FK table. and one to one relationship is joining two PK tables. is this accurate?

I need clarification...

plz

georgedwilkinson
08-18-2008, 11:22 AM
No. 1:1 still uses PK/FK, but you can choose to use the FK as the PK in the other table (not sure why you'd do that).

There are very few good reasons for a 1:1. They usually relate to implementing polymorphism or compensating for someone else's bad design (not a really good reason IMHO).