RE: DB design basic question

From: Ibrahim Shameeque (IbrahimShameeque_at_discussions.microsoft.com)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 01:53:06 -0800

You can define a One-To-one relationship just by including the manager table
id to the deparment table.
If you like to define a relationship then both related columns should be
primary keys or have unique constraints

"Francois" wrote:

> 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
>
>
>

Relevant Pages

  • Re: DB design basic question
    ... The FK with unique constraint will ... Francois ... A department HAS A manager. ... > Best regards, ...
    (microsoft.public.sqlserver.programming)
  • BCM and outlook
    ... How can I query directly the Business Contact Manager ... Anybody knows where this is located and in which format? ... Francois ...
    (microsoft.public.outlook.contacts)
  • DB design basic question
    ... I would like to know how i can relate 2 tables knowing that their relation ... A department HAS A manager. ... Best regards, ... Francois ...
    (microsoft.public.sqlserver.programming)
Loading