I am developing a web based training application, consisting of
various lessons and quizzes. The user will have to log in at the
begining of each session and I would like to keep track of which
quizzes the user has passed.
I am a little perplexed about how to structure the tables that will
keep track of that information. My initial idea was to have a
passedQuiz table with the user's ID and an quizID for each of the 10
or so quizzes as fields. The fields would initially be set to false
and upon passing of a quiz, the corresponding field would be updated
to true. My question is that not only do I want to know the quizID,
for example "pitch_basics," but also the name of the quiz, for example
"Pitching Basics" in order to display that to the user and to
administrators. The only solution I can think of is to create an
additional table with the quizID and quizName as fields. Then when I
would query the passedQuiz and then quizName again to get the actual
name of the quiz.
Is there another simpler solution?
Thanks for any help.
marissa