Re: 3NF question

There is no such thing as a"Magical, universal id number"; newbies use IDENTITY or other proprietary auto-numbering devices to mimick a sequential tape file when they do not understand RDBMS and keys.

I like to tell people that do this kind of programmng that God put a 17 digit Hebrew on the bottom of everything in creation and they ought to use it.

Your rule seems to be:
Login -> Pass, Description

or:
CREATE TABLE Passwords
(log_in VARCHAR (8) NOT NULL PRIMARY KEY CHECK(??),
password VARCHAR (8) NOT NULL
CHECK(??),
user_descr VARCHAR(25) NOT NULL);

You saw how haivng that ID in the table messed up normalization and would have destroyed your data integrity. Received on Sat Jan 08 2005 - 11:06:37 CST