Originally Posted by Old Pedant
I would stay where you are.
And as for your comment about being able to change section/dimension/et al. names if you used AUTO_INCREMENT primary keys...
Tch. You now do get a "shame on you". For forgetting that YOU were the one who originally mentioned ON UPDATE CASCADE.
Gee, just when I was on a roll...
I didn't forget, but it just seems that some people feel that using ON UPDATE CASCADE is "hokey"...
Hmmm??? What was that about "flexibility"??
Notice that I did *NOT* manually change the value of section in the section_dimension table!!!
MySQL changed it FOR ME, thanks to ON UPDATE CASCADE.
Who needs those stinkin' auto_increment fields, anyway?
So it sounds like you are pretty strong in the "Natural Keys" group...
In your eyes and experience, are there any compelling reasons to use "Derived Keys" over "Natural Keys"?
I guess I can see pros and cons in both ways...