Re: Nulls, integrity, the closed world assumption and events

Neo wrote:
> Ok, so would the MV solution for persons with cars with mfgs look like
> this? (If not, please show)

>
> OTLT
> NSN
> POR
> ASM
> GM
> HND
Maybe more like:
Validation Table
Car NSN Nissan
Car POR Porsche
...
Mfg GM General Motors
...

> Person Car
> john
> bob NSN, POR
> tom ASM

Yes,

> Car Name Mfg
> NSN nissan
> POR porsche
> ASM aston_martin GM, HND

Need only the Car & Mfg codes in this table.

CarManufacturer Table
ASM GM, HND No need for your other entries if there is no CarManufacturer to note

> Mfg Name
> GM gm
> HND honda

this is part of the Validation Table

> Can you show a query to find what has things that are manufactured by
> something whose name is honda? Below is dbd's:

LIST Cars WITH MfgCode = "HND"
or
LIST Cars WITH Mfg = "Honda"

Both MfgCode and Mfg would be virtual fields added to the vocabulary of "Cars"
If you want to list people who have a car manufactured by Honda, then similarly you would include Mfg in your Person vocabulary so you can ask such a question about a person

LIST Person WITH Mfg = "Honda"

If you want to list people who only have cars from Honda, as best we know

LIST Person WITH EVERY Mfg = "Honda"
and so on. --dawn

> (get * has (get * mfg (get * name 'honda)))
Received on Wed Jan 17 2007 - 22:35:47 CET