0

I'm trying to create ER Model for the Quiz game and I need help. What is the best solution for tracking user answers in the specific game?

What do you think about putting it in GamesByUser table (GamesByUser would have a List<QuestionOption> )

ER Model without tracking user answers:

enter image description here

Domagoj Hamzic
  • 300
  • 3
  • 17

1 Answers1

1

You ask them a question... then they give an answer.. those things seem pretty directly relate so I would related them to the 'game' in an equivalent way.

Game
 - GameQuestion
     - GameAnswer
          *GameID
          *PlayerID
          *QuestionID
           OptionID

* = Key
JeffUK
  • 4,107
  • 2
  • 20
  • 34