PERL/MySQL

Wednesday, February 11, 2004

Quiz Database

 

 

Write the application at http://www.andrews.edu/~shilling/perl/quiz1.htm using only PERL and MySQL.

 

Complete the project using the following steps.

 

  1. Rewrite quiz1.htm in PERL.
  2. Create a table called STATE in MySQL.  It should store states and an id for each state. 
  3. Use the STATE table to populate the drop down box (state eg. MI, IN etc) on the first page of your application.
  4. Add functionality to quiz2.cgi so that the registration information is stored in a table called REGISTRATION.
  5. Create a table called QUIZ in MySQL.  It should store
    1. A quiz question
    2. Quiz answer a, b, c, d
    3. The correct answer
  6. Use the QUIZ table to populate quiz2.cgi.
  7. In quiz3.cgi retrieve the correct answer for each question and compare it to determine how many points the student scored.
  8. Alter the QUIZ table to include a category field.  You can then have different categories of quizzes.
  9. Add functionality to allow the user to choose what category of quiz he wants to take first.
  10. Add functionality to allow the user to see which questions he got wrong and display the correct answer.
  11. Create a table called SCORES.  Add functionality to allow the script to store the students score in the table SCORES.
  12. Allow a student to view his score sheet (students can take quizzes multiple times).
  13. Add functionality to allow an administrator to modify questions and answers stored in the QUIZ table