Re: TRM - Morbidity has set in, or not?

Bob, I'm sure I'm missing something, but I can't see it. If it wouldn't be too much trouble, would you or J M Davitt give me a small example? Or maybe you can correct mine:

Condider, as in Davitt's example above, a Date domain D that enumerates all the possible dates (leave it a 5 days for the example):

D <-> 2006-01-01 2006-01-02 2006-01-03 2006-01-04 2006-01-05

and a single relation with two columns Date-of-Birth (DOB) and Expiration date (EXP) with indices pointing to D:

ID <-> 1 2 3 4
DOB <-> 3 2 5 4
EXP <-> 1 5 5 3

Are the columns stored like this in TRM? If not, how are they stored? If they are stored like this, what advantage is there to pointing to D instead of just storing actual date values in DOB and EXP?

I realize I must sound like an idiot, but I would appreciate any help or explanation. Thanks. Received on Tue May 16 2006 - 05:22:06 CEST