I wonder whether it is possible for a weak entity to have another weak entity dependent on it.

Specifically, I have a strong entity QUIZ which comprises of QUESTIONs unique to that QUIZ that I have let QUESTION be a weak entity. Inside each question, there can be many multiple-choice candidate answers which are only available to that question, which actually only makes sense if I use another weak entity for them (because each answer has got some other attributes as well, such as whether it is correct or not) and then identify its relationship with QUESTION.

If weak entity dependent on another weak entity is not possible, what would be the solution here? A very clear need is that questions are only available to a certain quiz and indeed candidate answers are only available to a certain question.

Thanks so much in advance.

  • My question is why is QUESTION a weak entity? Quizzes, questions, and answers, as a concept, should all be strong entities typically. A primary key should exist for all of them; that ensures referential integrity among them.
    – J.D.
    Aug 30 '21 at 3:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.