Just a quick question.
I just inherited a database a week or so ago, and I noticed something in one
of the main tables that caught my attention.
The USERS table has the primary key as User_ID Varchar(50)

Hi, I have a problem and I am not sure how to go about it.  I have the table
w/ the following columns:
userID, name, value
The userID is a foreign key.  What I need to do is find distinct

I need to create a database or something that will allow me to input all of the results
of a survey and then search the results for trends and stuff. For
example, it might have questions like:
1. Your age: [5-10], [11-20], [21-40], [41 and over]

This is a rookie question. I will be implementing a multi-user desktop
application using JDBC to access a database.
I plan on having one of the office personal computers (no server) host the
database and the

  I'm working on a Windows laptop application with
modest database size requirements.  But I would like a
nice SQL interface.  The application needs to run on
Win98 and later.  We are still deciding the memory

Does anyboudy knows how I can make a script in Filemaker which opens Word
and import a few fields from Filemaker to Word?

I am writing an application that has to either communicate with DB2 or
MySQL.  I am having trouble coming up with a query that casts a column
to integer (or real but I currently only need int) that can be written
the same way in both databases.  I can write a query that works in

What are some peoples longest uptime running which servers

Is here anybody who knows how to easily replicate a secured Access
database? Is it possible to use the Briefcase with secured databases? I
tried to simply drag my MDB file to a Briefcase but Jet dodn't allow me
to do this. What should I do?

I'm using OpenOffice.org 1.1 as a graphical front-end to MySQL.  I
installed MyODBC, and am following the instructions as per here:
http://www.unixodbc.org/doc/OOoMySQL.pdf
Everything seems to go smoothly until I get to the table creation

I have a delimited text file that has a column of dates in the form
2003-10-11 10:24:53.  I can't get past a type conversion error when
atempting to import this into a date/time column.

i have the following relational schema representation:
Hotel(hotel_id{pk},name,#OfRooms,address,postcode)
is this not in 3rd normal form, because i could work out the #OfRooms from
the address,postcode and name of the hotel? or is it in 3rd normal form if i

(This question concerns data modelling of time series data in a relational
database.)
Suppose I have time series data.  (The actual data are from the Public
Budget Database, available from the OMB at whitehouse.gov.)

I have an existing schema with an address table.  One address can
belong to one of several entities, a person or a company, for example.
The existing table has foreign keys for each of those entities, with
only one key in use per row.  If the company fk is null, then the

when drawing a conceptual database model in uml, how do i know that i dont
have too many relations drawn between the entities? For example if i have
the entities: Hotel, Booking, Room and Guest, they all stand in a certain
relationship to one another, so i could just connect each ...