Subject Re: [ib-support] Re: time series and FB/IB
Author Phil Shrimpton
On Tuesday 10 December 2002 15:03, you wrote:


> #
> 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


Linux 2.4.4-4GB
2:59pm up 6 days, 21:26, 1 user, load average: 0.75, 0.48, 0.20