I am trying to learn SQL and RDBMS theories. To acheive this, I
decided to assign myself a project.
My project is basically, account for my NFS mounts, and keep track of
them. I want to see which filesystems are growing, and which

My beginner's book on RDBMS theory by Louis Davidson (APress) says
that there's a trend towards using GUIDs (artificial keys) as
computing power increases.
This makes sense, though I do appreciate the point made by a poster

One thing that's not clear to me is when it's appropriate to create a
one-to-one relationship. I mean, in some cases it's obvious, if there's a
set of data that wouldn't always apply; then you'd want to create that set
of fields in a separate table with a one-to-one relationship. ...

I'm getting the hang of database architecture design I think, along
with easy to code, drag-and-drop Access 2003 forms programming--great
front end.
But I have a question about a form involving three tables--and I'm not

It's time for me to ask another dumb question.
The term "data sublanguage" appears in Codd's 1970 paper.  I kind of glossed
over it when I first read it,  figuring that my intuitive grasp was close
enough. Now I'm wondering whether I really know what "data sublanguage"

http://www.idera.com/Simon/
How would you like Simon's job?

Just wondered if anyone had seen this:
http://www.regdeveloper.co.uk/2007/12/17/amazon_simpledb/
While in principle a globally accessible database sounds like a great
idea, closer reading yields...

sorry to bug you but...
if i want to define a datum in terms of who owns what, what branch of IM
is it ? (yes i know it's not a computer-bound thing)
f'rinstance SSN...

Suppose I want to create a schema for
    S = student,
    J = subject,
    T = teacher,

OK, this is about my fifth day doing databases, and I've read about
1NF, 2NF, 3NF here: http://www.utexas.edu/its-archive/windows/database/datamodeling/rm/rm7.html,
and I have a crappy book by a guy named Louis Davidson (APress), full
of typos, bloated, and light on theory, but ...

It seems to be a common enough problem, but it doesn't seem to ever be
properly addressed in data modelling books, and from reading on the
web its clear that other people have had this problem as well as had
multiple solutions presented, but its unclear what is actually the

In paper "Independence of Logic Database Queries and Updates" by C.
Elkan it is proven that for logical databases query independency from
updates problem is undecidable. In some papers I've seen claims that
this problem is also undecidable for relational databases (the papers

The connection between objects and databases seems to be a recurring
theme here on c.d.t, so I'd like to contribute one observation.
Consider a Substring relation:
Substring

http://www.amazon.com/Handbook-Relational-Database-Candace-Fleming/dp/0201114348
/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1197329088&sr=1-1
I know this is a theory group, but at the end of the day the rubber must
meet road.

Valentina Office Server, Valentina Embedded Server and the free
Valentina Community Server for Linux now support custom database
properties, some of which include both read and write properties. This
treats databases on servers as objects, much as modern programmers