I have another question.

I need to develop an applicatio to manage a db structure.

A client's tecnician want that the db have a dynamic schema, thats is
in the time the user may create and insert new tables whit new columns
and the hew table have referenze relationship with the db static side.

I try to propose a db structure that are all static (no new table
create in the time) with no information create on the fly but all in
rows and fields defined at the db creation. The client's tecnician say
that is solution (new table create in every moment, manager
application interact with the db catalog to know new table and new
columns to manage) are fully compliant with the Codd Rule.
I have another idea. I think aren't good thing to have a db structure
dynamic and have an application that interact with db catalog to know
the db structure
(i think the client's tecnician want use a particular table name
standard or simply navigate through the relationship to search new
table in the db).

What's your idea??

in the time the user may create and insert new tables whit new columns
and the hew table have reference relationship with the db static side
....What's your idea?? <<

The man is an idiot. You might want to get an new client. He does
not understnad how an RDBMS works.

Ok, im completaly agree with you but the tecnician say the dynamic
solution is compliant with all Codd rules.

Now i have two question:

1) Anyone knows what say Codd about dynamic DB schema variable in the
time? (I suppose the tecnician have no doubt that same Codd'r rule
approves the dynamic schema)

2) this is my curiosity on a question really theoric. The 12 Codd's
Rules are applicable to DB design or to RDBMS implementation? Or the
two things togheter? I think that the rules ( i.e. like numer 5 or 7)
are more inherent to RDBMS and not DB schema on the other hand the
title of the Codd'a article is :"Is your RDBMS really relational?".
Some other rules (like 10) are more aboiguos. So if i have a db
structure described with as E\R diagram and implement inside a RDBMS
like Oracle and SqlServer is it correct to say :"The db structure is
compliant with all the Cood's rules the the RDBMS implements" ?

Pheraps my question is really ingenuous and whithout pratical
application but i have a biug doubt on this argument.

PS
Excuse me for my awful english )

thanks in advance

joe.celko (AT) northface (DOT) edu (--CELKO--) wrote in message news:<a264e7ea.0308221307.2a3db380 (AT) posting (DOT) google.com>...

On 22 Aug 2003 00:00:42 -0700, alessandro.toaiari (AT) address (DOT) it (alex)
wrote:

Having users design tables is a risky, risky business. (I'm being
charitable. It's really much worse than risky.)

--
Mike Sherrill
Information Management Systems