Our company is about to embark on rewriting our entire application to be truly
client/server based, and bring the UI up to .NET. One of the additional services that
our CEO wants to provide is the hosting of the software ourselves (to save our smaller
clients the licensing costs of ...

Hey all.
I'm trying to get hold of a database of books, preferably in sql,
access or something easily convertable to those.
The database should be like a library's, with records containing title,

I am looking for some relational algerba exercises(with answer).
I need some problems that is a little more challenging
Anyone got a link or website ?

Kind of odd question - if you like puzzles then read on.
I have been working with a number of databases in my life, but nothing
come close to this one.
The point is I dont recall the name.

I don't know if this counts as database theory or not so feel free to
tell me this is an inappropriate group for this post but anyway: can
anyone please offer any advice as to what would be the right pattern
(is pattern the right word?) to model the following scenario in a

Hi.  I apologize if this post is off topic but it doesn't relate to any
particular database, so I'm posting here.
I've come to work for a new (very small) company as an application
developer.  The legacy code that is here is rather poorly written and

This looks like a good opportunity to post a reworked snippet from my
exchange with Marshall.

I've discovered a new approach to storing ordered hierarchical data in
RDBs. As far as I know there is no similar model out there and it
differs significantly from traditional models (such as adjacency list,
materialized path or the nested sets approach). A brief article

Tchuzhie Giri wrote:

I'm going to design a db for an Interface Requirement Specification
Tool.
In practise I have the following main tables:
-System

I am looking for documentation and best practices to develop a database
and support it.
This tool and/or set of procedures should be able to:
* generate SQL statements to upgrade one version of a database _safely_

Consider
table PolarCoordinates (
   theta   real,
   R        real,

Here's what I'd like better than embedded SQL in a programming language.  Or
so I think.
I'd like a programming language whose syntax and semantics comprises both
the functionality of a good general purpose programming language,  and a

bit of a noob here, but ya'll are nice, right?  ; )
Scenario:
Building an EDW for a dashboard app.
First element of the dashboard is...Finance, of course (probably be

I have two questions related to theory, practice, or principles of
designing an application's schema for a relational database.
A) Is it true that a graph (as in graph theory, nodes and edges), when
represented recursively in a schema, is considered a nemesis to DBAs