I have a table from which I'm trying to find rows with datetimes that
fall within a particular period. These might be Today, Monday, This
Week, This Month, August, etc.
My problem is that the report must be from the point of view of local

I have Tags and Articles in a many-to-many relationship - Tags form a
taxonomy for Articles.  This taxonomy is then used to build the
navigation of a site displaying the information in Articles.  Thus Tags
need to be given relations - a Tag can have many child Tags, and a

I have the very strange problem with
the MySQL database [4.1.18]. I'm using
it with PHP5.
I have the table "pages_view" which

For our project, we need to have a history table for almost every table
in the data model. the history table mirrors the original and has a
couple of extra columns like date, transaction type and username. There
are two ways of populating the history tables:

I'm trying to make a good model for a following problem.
Application is about to help, let's say, ROOMMATES to keep track of
payed/not payed BILLS for a house they live in.
I thought i could make 3 tables:

Imagine you have a Table Employees, with values ID (PK), Name,
Supervisor (FK).  Supervisors are also employees, so 'Supervisor' is a
self-referencing foreign key to ID.
We realise that supervisors supervise more than one employee.  Now

Sorry for my bad english.
I want to add a child(Tom) to Chuck but not on the left of DONNA but
on the right of FRED.
Can You help me ?

I have been involved in developing database applications on and off for
many years, starting with COBOL and proprietary SQL databases (the good
old days!) and more recently using Access.
In an attempt to avoid the difficulties in distributing Access

I need to work with a database design that drives me crazy!!
We send out forms to collect learner data and teacher data. The
database in wich it is stored was designed as follows:  All of the
different tables have only 3 attributes in it: 1. The Question Number.

I was able to connect to MS SQL Server 2005 on my computer but after a
while I can not. When I want to connect to it using MS SQL Server
Management Studio I got this error:
An error has occurred while establishing a connection to the server.

I am new to database programming, started this week!  I am using MySQL 5.0
with myphpadmin as the interface to it.
Basically I would like to know if  there is some way to get a database to
perform automatic calculations, for instance, to make things simple, lets

I have four entities: location, department, municipality and sector.
municipality is a subtype of department, sector is a subtype of
municipality, and department, municipality and sector are subtypes of
location. Here are their relation schemas:

BOOK ANNOUNCEMENT
DATA STREAMS: Models and Algorithms
Ed. Charu Aggarwal
Springer.

Hey All,
I'm writing a program in c-like language (VTS) which accesses an ODBC
database with SQL commands. In order to use the SQL commands you must
connect to the database using a ConnectODBC() command in the VTS

I need to split a Oracle data definition SQL script file (DDL script) to
many files, each file corresponding to one command category (table
creation, constraint creation, index creation, etc).
Do you know some tool to do that ?