Re: Another newbie question
Date: Fri, 15 Feb 2002 16:31:03 GMT
Message-ID: <bJab8.143792$rt4.13103_at_afrodite.telenet-ops.be>
ministry_id ?? Another table??
"Chi" <webjunk4me_at_hotmail.com> schreef in bericht
news:25d4a987.0202141140.58e26c10_at_posting.google.com...
> If a company is setup in fthe following manner:
>
> COMPANY has many DIVISIONS which has many BRANCHES which has many
> UNITS
>
> and I have 4 tables to represent this:
>
> COMPANY
> -------
> COMPANY_ID (PK)
> COMPANY_NAME
>
> DIVISION
> --------
> COMPANY_ID (FK)
> DIVISION_ID (PK)
> DIVISION_NAME
>
> BRANCH
> ------
> MINISTRY_ID (FK)
> DIVISION_ID (FK)
> BRANCH_ID (PK)
> BRANCH_NAME
>
> UNIT
> ----
> MINISTRY_ID (FK)
> DIVISION_ID (FK)
> BRANCH_ID (FK)
> UNIT_ID (PK)
> UNIT_NAME
>
> What value, if any is their in cascading PK's to FK's down thought the
> tables? Does this violate normalization?
>
> Thanks.
Received on Fri Feb 15 2002 - 17:31:03 CET