Quiz with database:

 

You are to write a program that will put up a quiz for students to take.

 

The questions must be taken in random order from a MySQL Database so that everytime the quiz is taken, a new order of questions will appear.  You need a database table for the questions.

 

You also need a database table for student information including user name and password as well whether the person has taken the quiz or not and if they have the grade they got on the quiz.

 

A student must enter a username/password to be able to take the quiz.  You will need to check the password against a database table containing this information.  A person is only allowed to take the quiz once, so you must keep track of that in the table. 

 

The quiz should have 10 questions with equal weight.  The answer will also be carried on the database.  You can decide whether you want to use true false or multiple-choice questions. 

 

When the students submits the quiz, it should be graded and a grade returned to the student and written to the database table.