Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 21 Jul 2004 20:39:36 -0700
Message-ID: <4b45d3ad.0407211939.47e9bebd_at_posting.google.com>


> > The following example (carried out far enough), is even more
> > impractical, if not nearly impossible. Try representing the following
> > in RM without NULLs or redundant things:
> >
> > thingA: john take final
> > thingB: john receive 95
> > thingC: thingA cause thingB
> >
> > In effect thingC would be:
> > (john take final) cause (john receive 95)
>
> ID subject verb object
> -----------------------------------------------------------------
> thingA john take final
> thingB john receive 95
>
> causing event causal relationship name caused event
> -----------------------------------------------------------------
> ->thingA cause ->thingB

In the above (doctored), the schema (which is also data) has a redunancy. Both tables are representing Subject/Verb/Object relationships. They should be in one table. Where/how would one store the following:
((john take final) cause (john receive 95)) VerbX ObjectY.

A preliminary implemenation using XDb2 is shown at www.xdb2.com/Example/StudentActivityScore.asp Received on Thu Jul 22 2004 - 05:39:36 CEST

Original text of this message