Designing primary keys

When creating a primary key for a table, we have a few options:

• Composite key
• Natural key
• Surrogate key

Each has their own advantages and disadvantages, but by and large I always wind up going with the last option.

View Article