database table design advice needed

[psycoperl]

I am currently working on a database to track test registrations.

There are currently 22 possible test codes which are stored in tblTestInfo. The test codes are text based if that matters, some may have "-" in them but no spaces.

I need to assign one or more test codes to a particular test session what would be the best way to do this?

I need then to also figure out a way to query the session to see if there are seats still available.

Any guidance you can offer would be great.

 

[Joe4]

Based on what you have said, maybe something like this, a table with three fields:

TestSession
TestCodeIndex
TestCodeValue

So your data might look like this (note how the TestCodeIndex value starts over at 1 for every new session).

TestSession   TestCodeIndex   TestCodeValue
Session1             1           abc-123
Session1             2           mmm-444
Session1             3           xyz-789
Session2             1           mmm-444
Session2             2           xyz-789
Session3             1           abc-123