always be being added to the table. Each course will have many quizzes and
questions that need to be stored. You would not want to have a single QUIZ
table with a composite key of COURSE_ID and QUIZ_ID because potentially this
table would become prohibitively large, correct? Also, each quiz will have
many questions, stored in a QUESTION table. This even more so would become
prohibitively large if you stored questions for every quiz in every course
in one table. Sooo, you would want a QUIZ table and QUESTION table for each
course, correct? If so, these table names would be assigned dynamically.
That's easy enough if you just, say, appended the COURSE_ID to the end of
the QUIZ or QUESTION table, but you run into a problem if you want all
database access to be through stored procedures, as I don't know of a way to
use dynamic table names in stored procedures with SQL Server. Is there a
better way of doing this? Thanks, Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
