Re: Which normal form is this violating?

> SQL prevents you from having two tables with the same names, but
> relational theory says that since a table is a set, it can appear only
> once in a schema, no matter what the name.

I have wondered about this one. Does the theory really say that you are not allowed two relations in a relational database that differ only by name?
Such a restriction also suggests that it is not a good idea to allow two relvars that are identical in all but name in a database. They would need to be restricted from ever containing the same relation.

I can think of many valid 'business' situations where I would want more than one relvar in my database with the same number and type of attributes.

Is the getout clause to use different attribute names? E.g.

CREATE TABLE Managers ( Manager_id Type: employee_identifer) ; CREATE TABLE Grunts ( Grunt_id Type: employee_identifer) ;

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Fri Apr 26 2002 - 20:19:22 CEST