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: Cimode <cimode_at_hotmail.com>
Date: Mon, 15 Oct 2007 14:03:09 -0700
Message-ID: <1192482189.173671.252090@e9g2000prf.googlegroups.com>


On 15 oct, 22:13, dutone <dut..._at_hotmail.com> wrote:
> 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 *no case* presentation should determine design. Proper design should be the consequence of studying sound principles of relational modeling.

For more info...

Introduction to Database Systems. CJ Date Received on Mon Oct 15 2007 - 16:03:09 CDT

Original text of this message

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