Open MySQL

Step 1: You must gain access to the Purdue server that distribute MySQL database contact Mark Sharp.

   Enter SQL commands to gather data

    Step 1a: Once access is gain, and password assigned, Log into the MySQL database.

    Step 2a: Once log on the database system. Type in the following commands to get the data of the survey results from each tutor.

        SELECT Question.question_number, tutor.t_id, t_fname, t_lname, response, response_date

        FROM   Tutor, Question, TutorQuestion, response

        WHERE tutor.t_id = tutorQuestion.t_id AND tutorQuestion.question_number = Question.question_number

        AND Question.question_number = response.question_number

        ORDER BY tutor.t_id;

        This will display a list for all the survey response in regards the each tutor in the database

        The tutor id, first and last name question number, and the response for that question.

BACK