I think we've recently discussed lists and sets at length in the context of
the problem domain.  IMO, we can give that a rest, at least for a while.
We've discussed how a set (or pizza toppings) might be stored in a list,
for the sake of convenience, but the retrieve dand used as if ...

I am reading Date's Databases in Depth now, and having trouble with
expressions like this (it shoud return supp. numbers with numbers of
distinct parts each suppliers supplies):
WITH ( SP RENAME ( SNO AS X ) ) AS R :

I'll be back in the office next week Tuesday, but while I'm online I
thought I'd toss out a question.  I've done a little work on the
following question, but have more to do and thought others might be
interested in jumping in on this one:

research.microsoft.com/users/lamport/pubs/future-of-computing.pdf
"The Future of Computing: Logic or Biology"

Hi.  I am doing some research of the k-nearest neighbor method of data
mining and it certainly looks like it would fall under the category of
a supervised method since pre-made classifications seem to need to
exist before starting.   Does anyone know of a variation where there

Assume one accepts, as I do,  the argument against nulls put forward by
Date et al. Would it be fair to say that at this point in time they
really don't have a solution to missing information?
In the latest edition, just published, of the Third Manifesto (TTM)

I have been looking around at Google without too much success because I need
some tips for a website I am making now. It is for a travel agency and the
core of the website are, of course, the accomodations that can be rent. A
table could have fields like an accomodation_id, the ...

I am modeling a table based on the following form example.
Form Section: Mood
===============
Use the following codes to indicate patterns of mood disorder.

I've just read "The Default Values Approach to Missing Information" in
Date's Database Writings 1989-1991.  I've also noted that in the 8th
edition of Date's main textbook, he refers to the "special values
scheme' for handling missing information, and points to an article in

We are currently debating what the best way to implement lookup tables
in our databases, and we there are two opposing  optinions.
1. If you are defining a database table that requires a lookup table,
then the foreign key between the tow tables should be an integer, and

This topic is a spin off from another topic,  where Marshall Spight brought
syntax and semantics into the conversation.
My term "the problem domain"  comes from a phrase that crops up over and
over in "Object Oriented Analysis (Coad&Yourden, 1992).  The complete phrase

Can anybody tell me the differences between the above mentioned terms?
Also please tell me if one can be the other and vice versa..please
elaborate with the helpof a table if possible. Also please tellme if
the below statement by me is correct..

We are currently debating what the best way to implement lookup tables
in our databases, and we there are two opposing  optinions.
1. If you are defining a database table that requires a lookup table,
then the foreign key between the tow tables should be an integer, and

This is related to a recent exchange related to declarative
constraints.  I know I've worked on it before, but I am still perplexed
on this one.  Here are two common options for handling constraints
(business rules):

Can someone please direct me to a tutorial or give some hints?
I am trying to develop a tree like database with MySQL.
I have main categories in one table. Now, each category has many subcategories and
subcategories have their subcategories etc etc. All together seven levels.