| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Relationship question
Hope someone can help.
I've got the following 2 tables:
CREATE TABLE SA."PROJECT"
(
"PROJ_NBR" NUMBER(10) NOT NULL,
CONSTRAINT "PK_PROJECT" PRIMARY KEY ("PROJ_NBR")
)
CREATE TABLE SA."PERMIT"
(
"PERMIT_NBR" NUMBER(10) NOT NULL,
"PROJ_NBR" NUMBER(10) NOT NULL,
"ADDR_NBR" NUMBER(10) NOT NULL,
CONSTRAINT "PK_PERMIT" PRIMARY KEY ("PERMIT_NBR")
)
I've got a 3rd table:
CREATE TABLE SA."FEE_DETAIL"
(
"FEE_NBR" NUMBER(10) NOT NULL,
CONSTRAINT "PK_FEE_DETAIL" PRIMARY KEY ("FEE_NBR")
)
The Entrees in FEE_DETAIL can have a relationship with both PROJECT and PERMIT tables (i.e., both projects and permits can have fees).
I've set it up to have non-identifying relationships with PROJECT and PERMIT. This required the table FEE_DETAIL to have 2 FK entries, one for PROJECT and one for PERMIT. That didn't seem logical.
Any suggestions on a good way to do this?
TIA
-- Bryce I don't like having disks crammed into me... unless they're Oreos, and then only in the mouthReceived on Tue Oct 08 2002 - 16:24:29 CDT
![]() |
![]() |