Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Unanswered: Student Quiz Database Help

    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.

    Thanks
    -Trig

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by Trigger12
    just using 1 table
    First mistake.

    www.r937.com/relational.html
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2008
    Posts
    3
    Thanks for the link George

    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.

    Thanks again
    -Trig

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    A huge amount of rows would be more like 5 million per student. 50 is tiny.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Have a go at defining each of your entities in this scenario.

    for example, a student is an entity.
    A test is an entity.
    questions and answers, perhaps?

    Once you've done this, try and describe the relationships between your entities in this format:

    One/many _____ has/have one/many ____

    e.g.
    One test has many questions.
    George
    Home | Blog

  6. #6
    Join Date
    Oct 2008
    Posts
    3
    Quote Originally Posted by Teddy
    A huge amount of rows would be more like 5 million per student. 50 is tiny.
    Yea, I didn't really think that one through

    Okay George,

    My entities are:

    Students
    Quizzes
    Questions
    Answers
    Attempts


    Many Students have many Test
    Many Test have Many Questions
    Many Questions have one Answer
    Many Answers have many Attempts

    So these would be my relationships, and each Entity would be a different table?

    How do those relationships look? And as for my keys

    Students - Primary key ( StudentID#)
    Quizzes - Primary key (Chapter#), Foreign key ( StudentID#? )
    Question - Primary key (Question#), Foreign key (Chapter#)
    Answer - Primary key (Answer#), Foreign key (Question#)
    Attempts - Primary key(Attempt#), Foreign key (Question# or Answer#?)

    Am I heading in the right direction? Thanks again for this

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •