Re: DB design basic question
From: MattC (m_at_m.com)
Date: 01/14/05
- Next message: Ibrahim Shameeque: "RE: DB design basic question"
- Previous message: Hugo Kornelis: "Re: SQL Statement Formatter"
- In reply to: Francois: "DB design basic question"
- Next in thread: Ibrahim Shameeque: "RE: DB design basic question"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 Jan 2005 09:39:33 -0000
You could make use the foreign key and then place a Constriant that the
column must be Unique.
MattC
"Francois" <francois@bettinghouses.com_NOSPAM> wrote in message
news:eYEaFhh%23EHA.3336@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I would like to know how i can relate 2 tables knowing that their relation
> is a one-to-one relationship.
> It is something like: A department HAS A manager.
> Department and manager have different PK and then I cannot have the table
> sharing to same PK to model my one-to-one relationship.
> But if i just use a foreign key, then it will make a one-to-many
> relationship, then how can I solve my problem?
>
> Best regards,
>
> Francois
>
>
- Next message: Ibrahim Shameeque: "RE: DB design basic question"
- Previous message: Hugo Kornelis: "Re: SQL Statement Formatter"
- In reply to: Francois: "DB design basic question"
- Next in thread: Ibrahim Shameeque: "RE: DB design basic question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
