ID design and primary keys

Author: Alexey Makhotkin squadette@gmail.com, (~2300 words) This is the first part of a systematic discussion of primary keys in database design. As usual, we present the material in a way that deviates from the traditional approach. This is basically a bonus chapter from the “Database Design Book”. The goal of this text is to teach you how to design your primary keys based on business requirements. In part 1, we begin at the logical level.