I can't quite figure this out. I'm trying to design a database in Access that will store and log students progress through an online quiz. Going to be using a Flash interface using ASP to pull/provide the info, but I'm working on the database for now.
I thought it was going to be simple, just using 1 table, to store the students ID as the primary key, then list their name, password ( for log in ) and answers to the problems on the quiz.
What I cant figure out though, is how to make it so that I can view results of quiz questions as a whole, as in, a function to view what % of the students got question #10 correct or not.
Also, to log different attempts at the questions. This seems like it would require an entire table for each student.
I'm at a loss of where to begin with these two parts. Any help would be wonderful.
I had a text book on Relational Database Design, but I didn't really grasp the concept of it. That link helped a bit more.
I know I'm going to have to use more than 1 table, but I'm wondering just how many. If i had an extreme amount of questions, am I going to have to make an extreme amount of tables?
Or, Could I make a table with primary key as the studentsID#, that contains name, password, email, etc. Then make a second table that has the same primary key of the students ID, but has a column for say "Question Number" and a column for " Correct or Incorrect"
But then the table would have a huge ammount of rows, and seems like theres a better way, I mean it would have 50 rows PER student if there were 50 questions, and in a class of 200 students, That would be a huge ammount of rows. ( Edit : Not even considering allowing for multiple attempts )
I'll keep reading over this and trying to think of ideas.