design question

I have a table: questions(question_id, content)

I am in the process of creating another table, titled as test, which should map a unique test id to multiple questions.

There are two possibilities to create this table:

1. test(test_id, a set of question_ids); the set of questions is stored as a nested table.
2. test(surrogate_key, test_id, question_id)

Which alternative is better? Or is there any other alternative that is better than the above two?

Thanks Received on Wed Dec 13 2006 - 10:15:18 CST