Re: design question

vnr1995_at_gmail.com wrote:
> 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

Is this a real life work related question or is this based on some class you are taking? Received on Wed Dec 13 2006 - 10:46:11 CST