1:1 relationships

From: Joćo Martiniano <martiniano_at_hotmail.com>
Date: Tue, 23 Jan 2001 15:45:56 -0000
Message-ID: <980264817.350023@cachalote.ip.pt>

Hello, I have a question that is puzzling me, and I hope i'm addressing the correct newsgroup.

I recently tried to implement a 1:1 relationship in Microsoft Access... but I couldn't.
I always thought that 1:1 relationships looked like this:

Persons

---

Person ID (primary key)
Age
Car ID (foreign key)

Cars

---

Car ID (primary key)
Brand
Model
Person ID (foreign key)

My question is: is this the correct way of implementing a 1:1 relationship (in Ms Access or any other RDMS) ?

Thanks in advance.
Joao Received on Tue Jan 23 2001 - 09:45:56 CST