A thread called "ID field as logical address" has just started.  I have
an unpleasant feeling that it is going to lead to a lot of squabbling
over how doing a silly thing is silly, and little else.  I don't want to
get involved in it.  However I do want to share a couple of examples

A helper for educated database practitionner who have to provide
explanations to uneducated audiences (it's also entertaining for
some)...
http://www.youtube.com/watch?v=40Lnoyv-sXg&feature=related

I'm confused about some recent trends in database design.
When I learned databases, about a quarter of a century ago,  the preferred
practice was to use natural keys to refer to individual table rows, unless
there's some real good reason to go with an artificial key.  I've run into ...

Price:$23.00
Image: http:///image.php?id=B000BY9FHY
Best deal: http:///index.php?id=B000BY9FHY
Moldex camo colored earplugs are camoflauge for reduced visibility and are tapered for easy insertion into any size ear canal. Soft foam and non-irritating, smooth surface provide lasting ...

Stackoverflow look good to me for certain kinds of questions and answers.
Crisp, clean questions draw fast, useful answers.
Things like syntax errors that somebody can't figure out.
Where I think it doesn't work so well is at fundamental education, changing

I would like to implement a referential integrity constraint.  Sounds
like a good idea, doesn't it?
The Oracle system I am working on has 11 lines reserved for address
information and they are all VARCHAR2. Upon investigation, the address

I'm trying to model a photo gallery, and i have a doubt on how to
implement it.
I have a table for users. I have another table for pictures. And
finally, i have a table for galleries (which are sets of pictures).

I have just been shown a log of a rollforward on a 2.6 system that had
just been patched.  The log showed 8 warnings about "Illegal Record Type
159".
What might that be?

I have posted a few ideas on implementing business rules in the
database:
http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/05/04/two-suggestions-
to-enhance-constraints-in-sql-server.aspx
I am very interested in feedback.

I'm curious as to SQL with Common Table Expressions is Turing
Complete.  Is there some kind of proof either way?
Thanks in advance for any hints, tips, pointers, etc. on this.
Cheers,

I've run into a design issue that I just can't wrap my head around.  I
tried to model here below with different types of information, as the
actual information I am modeling is confidential.
Here are the rules:

We've designed a web survey with a MySQL backend. The survey is
composed of a series of questions with a possible answer of 1-5 or N/
A, in a particular order. We have a table Questions that stores the
text of the question and its answer.