Hi all,
I know it is an old issue and probably boring but please cope with
me , it is a real world problem I am facing and I don't really like
circular relationship.

First table is Test, each test has many questions. On the other hand
each test has many Responses. So far so fine, but here is the problem:
I have another table for the answers: Each question has many answers
AND each Response also has many answers .

So there is s circular relationship between these tables which is
bizarre. Could you give me some hints to solve it?

Regards,
Arash

Arash wrote:

Why not? Is there something inherently wrong with that?

What is the meaning and use of your data?

Can you give a realistic population sample?

On Oct 30, 5:06 pm, mAsterdam <mAster... (AT) vrijdag (DOT) org> wrote:
Well in this case for example, there is two path to determine the
"test" for a answer ( query by using the response and query by using
the question), and there is not guaranty that both would be the same
It would be like:
test: id=1 name="Mathematic test",
questions id=1 description= "1+1", test_id=1
id=2,description ="2+2" , test_id=1
Response: id=1, username: "Adams" test_id =1
Answer: id=1, question_id=1, response_id=1, answer_text="2"
id=2, question_id=2, response_id=1, answer_text="4"