DB design basic question

From: Francois (francois_at_bettinghouses.com_NOSPAM)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 16:06:42 +0700

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: IT & Confidential Data
    ... confidential and sensitive data. ... We've a new IT Manager who's a great guy, and keen as mustard, but he ... seems obsessed with knowing where all the numbers come from. ... You get the network administrator to set permissions. ...
    (uk.business.accountancy)
  • Re: DB design basic question
    ... The FK with unique constraint will ... Francois ... A department HAS A manager. ... > Best regards, ...
    (microsoft.public.sqlserver.programming)
  • Re: ADSI
    ... Not knowing what objects you're using here, but is manager a valid property ... of objUser? ...
    (microsoft.public.scripting.vbscript)
  • Re: Laid Off Kaiser Hospital Worker Kills Himself, Wife & His 5 Children
    ... and did not attempt to assist us in the matter, knowing we have no job ... What did that manager do? ...
    (alt.true-crime)
  • Re: Problems with SPICE models from vendors
    ... >May news reader is uptodate within minutes. ... >Best Regards, ... >> manager at Analog Devices. ...
    (sci.electronics.cad)