Does anyone have a database developement project plan that they would
be willing to share with me?  I'm going to be project managing the
dev. of a Db, and I could really use a head start.  Anything would be
appreciated.

I have two tables A and B which satisfy various foreign key constraints
( A to B AND B to A).
I would like to add some date to A and some data to B. Once all the data
has been added, A and B will satisfy the foreign key constraints, but

Cheers to all,
I have a table with these data
service_id-----------entity_id
---5---------|--------1------

What seems like a simple problem has turned out to be quite a
challenge.
Let's say I have a table of data that represents various jobs
performed. The columns in this table are job ID, Start Date/Time, and

Hello! Can you give me sample codes written in Java for Database. Thanks!

I'm looking for a program for an architectural firm, for the purpose of
keeping a database of clients and jobs.  Can someone recommend a
program?

what good repositories (e.g. books) are there that contain lots of
examples of common relational database structures (e.g. names and
addresses of persons)?
Felix

Our small company is in the process of bringing a server in-house for
our in-house web application (with online ordering) & am wondering
about any tips for configuration, etc...
The server is most likely going to be a 2.8GHz xeon processor with

I found two ways to get the number o rows in a table using ODBC and I
was wondering if someone could throw some light on the performance of
the
two as far as which one would be faster and why:

I have no idea why this is happening.  Whenever I run this SQL command on my
MySQL database:
insert into compData values ('3002572819', 'ALFRAMED CORP.', '72-C
INDUSTRIAL ESTATE', '', 'SIALKOT, PUNJAB', '', '', '', 'PK', 'MM', 'A',

1. Is it bad design to have a table with two foreign keys that reference the
same table? For example a football player transfer table which would have
columns for both the leaving and joining club.
2. Are there any other methods of referencing other than foreign keys and

How can I do this in MS SQLserver (7.0 or 2000)
Update t1
SET (t1.v1, t1.v2) = ((SELECT  t2.v1, t2.v1       
                      FROM  t2

I've got to set-up a database on an Interbase SQL server.... I want to
do an ID for each entry.... In MySql it is easy using the AUTO_INCREMENT
attribute. I can't see anything similar for Interbase Sql.
Has aanyone any experience of a work around?

I am not familiar with Dbase at all. Can some give a "MySQL vs Dbase"
comparison? Thanks a lot
Tony

Please help.
Situation - I have 2000 assets. Each asset is idenified by a unique location
code. I want users to be able to book these assets on a daily, weekly,
monthly or a user defined time. Users should be able to book assets