Primary Key Question

 I was told early on in the world of DBA stuff that a primary key should normally
be a sequence number I generate. At times I have use two keys from other tables
when the table in question is a join table. The person I am now working with
doesn't think you need a sequence number if the table in question is an "end node".
(I don't know the correct term, but a table in which isn't refrenced by any other
table). Instead the primary key is made up off user inputed data in combination
of sequence numbers from other tables (at times having 4 fields making up the
primary key). How do people feel about this? Hot debate here!

thanks for any feedback!

tim
tringwood_at_yahoo.com Received on Thu Aug 17 2000 - 10:06:39 CDT