I am building a database to track and display (web, intranet) a truck
dealer's vehicle inventory. I'm running into difficulties in designing
the structure of the tables to hold the truck information.
Brief Description:

I need to create a four varible pricing matrix for my sales reps.  The
following variables will affect the price.
if distance increases, then price decreases
if reward increases, then price increases

Imagine you were knocking up a simple table of animals and their
predominant colors. Something of the order:
----------------------
animal     | color

Software in . Net to retriew yous Statistic data
Polaris.Net is for who, knowing the structure of database and SQL
language ,
they want realize statistics. Polaris.Net is for the producer of

In our system we have a table with one row ("today") that is used
solely to tell the application what the current processing date is (as
well as yesterday and tomorrow).  The table looks like this:
create table today (

I am building a contact management system and I have a
requirement for a contact category feature which allows a
contact record to belong to multiple categories. For example
a contact John Smith could belong to the categories

Can someone please help me identify the entities for an extended entity
relationship diagram for the below scenario.
Thanks.
EmJ.

I have been having a debate recently on another forum about database
market penetration and how to measure it.
My point of view would be that even for companies which *_only_*
produce databases (Oracle until recently, MySQL, say now), it is

I have a CMS (web content management system). It's based on MS SQL, with
a stored-procedure query layer and XSLT for the presentation.  Articles
are in an "article" table. Site structure is a hierarchy of Site /
Section / SubSection / SubSubSection, a simple tree of tables with keys

Almost everytime I see indices (indexes?) mentioned in text books or
papers, it seems they are relagated to the query optimization section.
Algebra/Calculus level primitives never take an index into account.
I'm wondering if there has been any work done on making indices more

Hi group, I'm currently searching for lecture about SQL in general.
There are a lot of books. But all of them, at least those I had a look
into, are far too explanatory for me. I mean they introduce some
conecept, construct or language feature by presenting an example,

     Many times when dealing with database updates I find myself
writing something like this:
                 Update .... set .. where ...
                 If (no update was done) then

I've heard people use the term "Flat Query" what is it?
Is it a query that is performed on one table?

Hi - I am looking for sources of any kind that have to do with
modelling objects, specifically organic molecules and are 3D, in a 2D
relational database.  Can anyone suggest anything?
Thanks,

I'm using MySQL. I have a table that looks like this:
+-----+---------------------+---------------------+

+-----+---------------------+---------------------+