Another newbie question

From: Chi <webjunk4me_at_hotmail.com>
Date: 14 Feb 2002 11:40:45 -0800
Message-ID: <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 Thu Feb 14 2002 - 20:40:45 CET