1. I have executed options 3,4,5, and 6 from the ExerciseEngine.java Class # --- 2. For the following exercise, refactor the content so that the content is current and makes sense to the user # ----- 3. After the exercise.php is refactored, make sure the "exercise-result.php" solution corresponds to the exercise submission page.

Data Normalization - Exercise

Data normalization

Objective: Explain how to normalize sample data.

Exercise Scoring

This exercise is worth a total of 10 points. You will receive up to five points for correctly answering each of the questions below.

Instructions

The following table is a prime candidate for normalization.

Examine the data contained in it and explain in your own words how you would normalize it. In particular, answer the following questions:

How many tables are required to normalize the data effectively, and what will they be titled?

How many columns will be included in each of the new tables, and what will their headings be?

Explain the rationale behind your answers to these questions.

Submitting the exercise

Once you have entered your responses into the text boxes, click the Submit button to submit the exercise and view one way in which the data might be normalized. Remember that you must submit all your responses to this exercise at once.