Is it Possible to Enforce This Relationship at the DB Level?

From: dutone <dutone@xxxxxxxxxxx>
Date: Mon, 15 Oct 2007 20:13:31 -0000

DB layout is as follows:

--------------------------------
| Client |
--------------------------------
1
|
|
0..*
-------------------------------
| Service |
-------------------------------
1
|
|
1
---------------------------------
---------------------------
| Spread*** Config | 1 ------ 1..* | Cell Config |
--------------------------------
---------------------------
1 1
| |
| |
1 |
-------------------------------- |
| Spec | |
-------------------------------- |
1 |
| |
| |
1..* |
-------------------------------- |
| Field |
1----------------------------|
--------------------------------

Every client has a spread*** that must implement a version of Spec.
For this version, the cell config must corresponding to cells in the
spread*** containing fields for the given Spec.

As long a Cell Config references a Fileld, th DB will be happy, but
the problem I have is making sure that the Fields referenced by Cell
Config are indeed children of the Spec referenced by Spread***
Config.

Is it possible to enforce this at a DB level? Maybe my model is
flawed?

Thanks

.

Follow-Ups:
- Re: Is it Possible to Enforce This Relationship at the DB Level?
  - From: Cimode
- Re: Is it Possible to Enforce This Relationship at the DB Level?
  - From: David Portas

Prev by Date: Re: Book about query processing / query optimization searched
Next by Date: Re: Is it Possible to Enforce This Relationship at the DB Level?
Previous by thread: New to the job
Next by thread: Re: Is it Possible to Enforce This Relationship at the DB Level?
Index(es):
- Date
- Thread