Re: Another newbie question
From: John Van C <jvanc_at_pandora.be>
Date: Fri, 15 Feb 2002 17:12:58 GMT
Message-ID: <ukbb8.143890$rt4.13246_at_afrodite.telenet-ops.be>
COMPANY_ID (PK)
COMPANY_NAME DIVISION
DIVISION_ID (PK)
DIVISION_NAME
COMPANY_ID (FK) BRANCH
BRANCH_ID (PK)
BRANCH_NAME
DIVISION_ID (FK) UNIT
UNIT_ID (PK)
UNIT_NAME
BRANCH_ID (FK) Received on Fri Feb 15 2002 - 18:12:58 CET
Date: Fri, 15 Feb 2002 17:12:58 GMT
Message-ID: <ukbb8.143890$rt4.13246_at_afrodite.telenet-ops.be>
this looks better to me
COMPANY
COMPANY_ID (PK)
COMPANY_NAME DIVISION
DIVISION_ID (PK)
DIVISION_NAME
COMPANY_ID (FK) BRANCH
BRANCH_ID (PK)
BRANCH_NAME
DIVISION_ID (FK) UNIT
UNIT_ID (PK)
UNIT_NAME
BRANCH_ID (FK) Received on Fri Feb 15 2002 - 18:12:58 CET