http://www.perlmonks.org?node_id=628218


in reply to Re: OT: updating database question
in thread OT: updating database question

Howdy!

Ack! Surrogate keys gone wild!

Seriously. My first thought is to wonder why the main tables use surrogate keys at all. In any case, adding a surrogate key to the third table doesn't necessarily add value.

If you want, say, to see all the qualifications Alice holds, you simply constrain the query to get them. The combination of name and qualification uniquely identifies the row already -- no surrogate key needed, along with its care and feeding.

yours,
Michael