One of the key of designing a database is picking the right primary key. I keep in mind several things when I design a database: If possible, primary key should not have a business meaning. Business meaning changes, some attribute that is unique now,
