Each relation should have one primary key: the set of columns that identifies unique entities. The set of columns may contain between 1 and n columns, where n is the number of columns in the relation.
Some database design applications allow alternate primary keys. In real life these are usually defined by creating unique indexes. -- Simon Oliver
