Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Is it Possible to Enforce This Relationship at the DB Level?

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

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Mon, 15 Oct 2007 22:00:50 +0100
Message-ID: <avSdnVktNtGMSI7anZ2dnUVZ8tqinZ2d@giganews.com>


"dutone" <dutone_at_hotmail.com> wrote in message news:1192479211.800346.53530_at_i38g2000prf.googlegroups.com...
> DB layout is as follows:
>
> --------------------------------
> | Client |
> --------------------------------
> 1
> |
> |
> 0..*
> -------------------------------
> | Service |
> -------------------------------
> 1
> |
> |
> 1
> ---------------------------------
> ---------------------------
> | Spreadsheet Config | 1 ------ 1..* | Cell Config |
> --------------------------------
> ---------------------------
> 1 1
> | |
> | |
> 1 |
> -------------------------------- |
> | Spec | |
> -------------------------------- |
> 1 |
> | |
> | |
> 1..* |
> -------------------------------- |
> | Field |
> 1----------------------------|
> --------------------------------
>
> Every client has a spreadsheet that must implement a version of Spec.
> For this version, the cell config must corresponding to cells in the
> spreadsheet 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 Spreadsheet
> Config.
>
> Is it possible to enforce this at a DB level? Maybe my model is
> flawed?
>
> Thanks
>

In principle it is possible, assuming your DBMS supports something like SQL's CREATE ASSERTION statement for example.

-- 
David Portas
Received on Mon Oct 15 2007 - 16:00:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US