I know it is an old issue and  probably boring but please cope with
me , it is a real world problem I am facing and I don't really like
circular relationship.
First table is Test, each test has many questions. On the other hand

I have a to design a structure for a table with many attributes
containing Yes of No values. The program I write, has to react in
different ways corresponding the Yes/No-values in the different
attributes.

Excellent resource has been found on software testing. Worth
Reading!!!
http://technical-talk.com/articles.asp

Let's suppose I'm writing a website where users search for movie
titles, and suppose there are 200,000 movies. The site is in PHP/
MySQL.
I'd like to implement a "fuzzy" text search so that similar movie

In An Introduction to Database Systems,  C.J. Date, characterises
value, variable and type as follows:-
"value" : An "individual constant" - for example the individual
constant that is the integer 3.  A value has no location in time or

DB layout is as follows:
--------------------------------

--------------------------------

I finally sprung for CJ Date's "Writings, 2000-2006" and skimming it,
noticed this point in chapter 10.  It reminded me of the recent posts
about avoiding books that start with silly sentences even though this
quote is from page 174:

I just got a new job (woohoo). First challegne I face is to build a
data model and a data dictionary of all the systems existing in the
organisation. I have a number of constraints to acheive this because
of the following

I never really took any effort to bother to know what these are until
they got in my way in otherwise fine paper:
http://arxiv.org/PS_cache/arxiv/pdf/0710/0710.2083v1.pdf
It defines an entity as a relation (aka table:-) with a single

While working on a db core on these last years, one of the question
that gave me most difficulty was what would be an efficient taxonomy
to list prequisites for a system to support updateable views.  I would
be happy to exchange on that subject.

I have a set of predefined constants with a set of predefined
relationships and am looking for a way to link them if possible to
ensure data integrity.
An example would be if I wanted to keep track of programs and I have a

I am developing a database design course for young PHP programmers. Here is
why:
CREATE TABLE tblShoes(
charSKU as Char(10) //first 3 characters indicate color,

I'm wondering whether it's possible to query time based inventory
status/quantity.
basically there are buying in (quantity increased), selling out
(quantity decreased), renting out (quantity temporary decreased) and