As part of this assignment, you have access to a dataset containing six years of customer surveys conducted through a randomized door-to-door survey across Singapore.

Specifically, the MySQL table containing the survey data, named six_yr_survey, contains the following fields

The 0–100 scores for exp_qual, qual, Val, sat, and loy is computed from answers to questions in the survey.

  • Assess the data type for each field in the MySQL table. Some of them may be less than ideal, given the field values in the dataset. Use the MySQL ALTER TABLE statement to make appropriate changes to relevant fields as necessary.