I'm a rank newbie at databases, designing a database to
keep track of purchases and inventory at a small company.
What would be the standard way(s) to design a database
where each record has a list of variable length associated

I plan to switch from an old database (paradox) to a new one.
I need security, speed and low cost.
Is MySQL the better choice ? Why ? Why not ?
What is the best operating system for install and configure the server

I am not able to find the answer to the following query.
A table has three columns: Year, Quarter and Sales price.
Each year has four quarters and values for corresponding sales price
for each quarter is given. Populate the table and give the output as

It struck me, that there does not seem to be a single language that
serves many purposes, suitable for
- business
- databases

I have a table with three fields (giver, taker, amount)
I have another table of people with two fields (id, name)
The fields "giver" and "taker" are match the values of "id"
I'd like to make a table (I've heard it called a distance matrix, but

I've been looking throgh the threads to resolve the issus of removing a
backup pending state from a tablespace, but when I tryo I get a message that
the DB is in use or Table space access is not allowed.  Any ideas?

Hello Group,
I have a little designing problem. I am designing a database partially
from scratch and partially from a excelsheet model.
Now I try to explain what my problem is at the moment:

How do i get the value of TotalQty from the sql string to
lblCouponNum.text
Dim sqlstr As String
       sqlstr = "select sum (NumberofCoupons) as TotalQty from

I have been working on a code generator  to convert a .SQL script to
1. html forms for data entry and editing
2. Perl scripts for saving the data to a given database.
3. Scripts to preview and edit A given row of data.

I'm no programer but still i do have problem that i think you could help me
with. If there are music, video, and text and someone would like to store
that together, what would be your advice - how to do it?!
The thing is: There is a meteor station with radio, VLF, ULF and Video ...

Suppose we have to design a database for a recruitment agency. There
will be a table "candidates" with fields "candidateid","last
name","first name" ; the languages mastered by a candidate as
well as the skills are separated into different tables. Eg. The skills

(I did a quick Google groups search of this
group and didn't turn up anything; I suspect
I don't quite have the right vocabulary for
this question. Suggestion are welcome.)

 I'm facing a problem trying to access R(A1,A2,...,A7,V1,V2,V3) by any
of one or more Ai fields in R, a relational table.
 Let's suppouse that R has not null Ai fields with Vi associated'
values; an user may provide A1, A3 and A5 as parameters, so in order to

Any recommendations for database design / data modeling / application
development?
Most 'database' books seem to focus a lot on administration and not much on
design and development.

I know the difference between centralized and distributed databases but I
can't find info on which type is used by which organisations.
For example when I think of a bank I would expect them to use a distributed
database since they could have one file for each branch or sort code.