Well, SQL is
not saying that you cannot create a composite key, it is saying that you can't have
multiple primary keys.
Have a look
at this link[
^] for an example of how to create a composite primary key
I suspect your schema design is exactly up to scratch though and may need some rethinking