> #
> f Bob has more that one shirt in his
> closet, you might want an entry for each in the Wardrobe table. If you
> key on Person and Clothes, this would generate a key violation.
> #
>
> Accepted - if person/clothes is not unique it can't be a PK.
>
> What's the argument for a generated key if person/clothes is unique?
Because it has business meaning. If your client/boss tells you that the next
update of WardrobeManager.exe should allow multiple shirts, you will need to
do a lot of changes on your DB to allow it, if you used a generated key that
has no business meaning, the change will be a lot easier
Phil
--
Linux 2.4.4-4GB
2:59pm up 6 days, 21:26, 1 user, load average: 0.75, 0.48, 0.20