Re: design question

Jonathan Lewis wrote:

>
> It looks like you should have three tables:
>
> questions (question_id, etc.)
> tests(test_id, etc.)
> questions_in_test(test_id, question_id, etc.)
>
> Why have you introduced a surrogate key ?

The shop I am presently in has a standard practice to add some unique id (like a sequence or sys_guid) to each row. I don't know either advantages or disadvantages of having that surrogate key. Received on Wed Dec 13 2006 - 15:50:54 CST