[OK, first of all, I know this is not a MySQL specific question, but I
couldn't find any newsgroup about SQL in general.]

Today I had an exam test for a course about data storage and processing,
with 20 true/false statements.

One of the statements was (translated from swedish):
"A compound key is a primary key based on at least two foreign keys."

I answered "False", but in the the published key answers they say "True".



What do you say about this? Do I really need two foreign keys to create a
compound key?

I have searched on google for the SQL standard definition of a compound key,
but I can't find any usefull information.



I have already emailed the teacher (no reply yet), but I though maybe you
can give me some arguments I could tell him _if_ he would claim that the
statement is correct.



Regards

/Jimi