Add More To My Quiz

The template of the quiz is all set up. The result that was shown is exactly what I need. I need you to modify this and use the database to keep all of these data. Store in the Database Questions Question ID – it is unique number to identify question – a question level – which level it should be media – the name of the video or audio type – which it is? Video or audio? correct – the number of the correct answer answer 1 – choice of the answer answer 2 – choice of the answer answer 3 – choice of the answer answer 4 – choice of the answer answer 5 – choice of the answer answer 6 – choice of the answer answer 7 – choice of the answer answer 8 – choice of the answer answer 9 – choice of the answer answer 10 – choice of the answer picture – an image show only for audio title (varchar 255) – the title of this question second – need number that will pop up the answers. Answers Sid - it is unique number to identify studentid – student id question_asked – keep record of all questions that was asked question_response – keep record of all questions that was response answer – keep record of all correct and incorrect answer level – The result of the level time_response – Keep track of time for each question time_total – Keep track of total time for each question taken – 1 is done with the exam -- 0 for new exam or resume to the exam date – need the date of when the quiz was taken. Students First_name – first name of the student Last_name – last name of the student Student_ID – student ID or number Error during the Quiz If there is no video or audio show during the exam, it goes to next page that display the warning message. The message says “Missing Video or Audio”. Save the result in the database and exit the exam. The user has to log in again to resume the exam where it stops at. If the exam was not complete, the user has accidentally closed the exam. It should save the result in the database. The user has to log in again to resume the exam where it was stops at. If there is any error during the process, it goes to next page that display “Error in the exam, please contact your professor” Then the professor click to close the exam. The user has to log in to retake the exam again. Back-End Quiz Need to edit/update/add question Need to able to change the rules. I need to create many different templates that able to use different kind of rules. Need to have nice table of result for each student that taken my quiz. I need to click any student and it displays the result of the chart. Front-End Quiz Update I need you to make it pop up in full screen. I don’t want the user able to control anything else but only to this quiz. There should be no toolbar, menu or anything. Make it nice and big that fill out the screen of the monitor. I need you to set up a page that check student id in the database before process this quiz. Also check if the quiz already taken then cannot take the quiz again. The admin panel should have a switch or something that allow the user able to take the quiz again. There are some questions related to media or audio. Either media or audio, it should loop only twice. After the first loop, the answers will show. There are some questions that related to timer. I need the answer show up at specific seconds. For example, on question #22, the answers show up in 10 seconds. Please store everything in the database that I can look back to see the result and questions.