| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: A Normalization Question
> > 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 Wed Jul 21 2004 - 22:39:36 CDT
![]() |
![]() |