Re: Table Structure Question

Marissa wrote:
> 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

Check out Sten Vesterli's site (www.vesterli.com); he has presented just that on the Berlin EOUG meeting - look for the QuoteGame.

-- 
Regards, Frank van Bortel