Assessment Test (PHP) Your client needs a web application that asks a series of questions. The answers to these questions will be stored or tallied for later use, and at the end of the process these answers will be used to generate a four-character result string. The client will supply the questions in a database, and will pay $900 for a working application. I. Architecture Specifications: The web application must be a multi-page MVC application with the following features: Entry Point (a) This page should reset any existing test sessions (b) A form to initiate a new test. This form should include a text box to enter a name, and a submit button to begin the test. Testing Screen (c) Displays 1 or more questions on screen. These questions are randomly chosen from the pool of unanswered questions. (d) For each question, display radio buttons for answer selection. There will be two possible answers to each question, and they should be shown in random order. (e) Below the questions is a "continue" button (f) When the button is clicked, record the scores for the answers and present another test screen with new question(s). (g) Continue until all 24 questions have been answered. No question should be answered more than once. (h) On the testing screen that will complete the last set of questions, make the button say "score test" instead of "continue". Results screen (j) The result screen must contain the following text: Based on your answers to these questions, your score is as follows: (k) Following the text, echo the 4-letter string score based on the formula below. (l) Also include a link to return to the main entry point. (m) Make the 4-letter score into a web link that links to the appropriate Wikipedia page for the score. http://en.wikipedia.org/wiki/ISFJ (n) Once the test is complete, store the start time, stop time, user name, 4-letter score in the a9_tests table. II. Assessment Scoring: The assessment scoring involves on tracking 4 integers: $ie $sn $ft $jp Each of these numbers starts at 0. Each question in the test will increment or decrement one of these integers as indicated in the source data (MySQL table a9_questions). Questions have two answers: If the first answer (a) is selected, you will increment or decrement one of the four variables. If the second option (b) is selected, you will increment or decrement in the opposite direction (1 becomes -1, -1 becomes 1). When the test is complete, it will be scored as a 4-character string in the following order:

Example scores: ISFJ, ENTP, INTJ, ESFP --- Notes/Hints: The questions must be presented in a random order each time. It might be useful to shuffle the questions beforehand or when the user starts the test.

----------

Creating the required mysql tables.

This will create the tables a9_questions and a9_tests.

The a9_questions table will have all the questions in it. You will only read from this table. The a9_tests table is where you store the final result of each test. You will only write to this table. Log into mysql. Once you are at the mysql prompt, type: source /home/d/a/dandrew1/public/assignment09.sql ----------

----------

---------- ---------

Variable f less than 0 f greater than or equal to 0 Sie I EE Issn N IF T P sip J