Re: Can we solve this -- NFNF and non-1NF at Loggerheads

// Create items in directory to classify things.
(CREATE *person.item ~in = dir)
(CREATE *dob.item ~in = dir)
(CREATE *month.item ~in = dir)
(CREATE *day.item ~in = dir)
(CREATE *year.item ~in = dir)

// Create an "atomic" date of birth 1/2/05
(CREATE *1/2/05.cls = dob)

// Create a non "atomic" date of birth 1/2/05
(CREATE *.cls = dob

        & it.month = +1
        & it.day = +2
        & it.year = +05)

// Create Alan and set his dob to "atomic" 1/2/05
(CREATE *Alan.cls = person

        & it.dob = 1/2/05)

// Create Dawn and set her dob to non "atomic" 1/2/05
(CREATE *Dawn.cls = person

        & it.dob = (*.month=1 & *.day=2 & *.year=05))

// Create Neo, he has two dates of birth, // one "atomic", the other non "atomic.
(CREATE *Neo.cls = person

        & it.dob = 1/2/05
        & it.dob = (*.month=1 & *.day=2 & *.year=05))

// Find persons with non "atomic" dob 1/2/05 // Finds Dawn and Neo. Sorry Alan.
(SELECT *.cls=person

        & *.dob = (*.month=1 & *.day=2 & *.year=05)) Received on Fri Feb 04 2005 - 23:24:35 CET