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

From: Neo <neo55592_at_hotmail.com>
Date: 17 Jan 2007 14:49:01 -0800
Message-ID: <1169074141.165597.276660@m58g2000cwm.googlegroups.com>

Ok, so the MV solution for persons with cars with mfgs look more like this (please correct any glaring errors):

Validation Table
?cat code? name?
Car NSN Nissan
Car POR Porsche
Car ASM Aston Martin
Mfg GM General Motors
Mfg HND Honda

Person Table
person car
john

bob          NSN, POR
tom          ASM

CarMfg Table
Car     Mfg

ASM GM, HND Queries to find cars mfgd by Honda:
Add MfgCode and Mfg as virtual fields to the vocabulary of "Cars" (? CarMfg Table ?)
LIST Cars WITH MfgCode = "HND"
or
LIST Cars WITH Mfg = "Honda"

Query to find what has things that are manufactured by something whose name is honda:
Add Mfg in Person vocabulary.
LIST Person WITH Mfg = "Honda"

Query to find people who only have cars from Honda: LIST Person WITH EVERY Mfg = "Honda"

---

Questions:
1) It seems all entities are moving to the validation table. Why aren't people in the validation table also?
2) Would a better name for the Person Table be PersonCar Table? 3) Adding virtual fields are in essense table joins? Can you show the ones to implement the above queries? Received on Wed Jan 17 2007 - 16:49:01 CST