In addition to Solution 1:
It would be very useful for you to learn some basics first, in particular, about unique and primary keys. Please see:
http://en.wikipedia.org/wiki/Primary_key[
^].
Pay attention for the section: "Differences between Primary Key and Unique Key":
Each table can have at most one primary key.
So,
no, you cannot have multiple primary keys. And you don't want it. It would not really make sense. The mere fact that the
multiplicity of
COLUMN expression
in the syntax diagram is 1+ should be enough for you.
—SA