Re: Another newbie question

(Chi) wrote in message 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.

Sorry that should read "COMPANY_ID" not "MINISTRY_ID" Received on Fri Feb 15 2002 - 17:40:30 CET