Question: What steps do you need to take to normalize the table from this diagram?

  1. Create another table to serve as a lookup for powers with fields for code and description, as well as a junction table with superhero names and power codes.
  2. Add a column to this table to serve as a record identifier, and make it the primary key.
  3. Extend this table to have additional columns "power4," "power5," and so on, to allow additional powers for each superhero.
  4. Convert this table to have column called "power," and add one record for each superhero-power combination, for a total of 15 records in this example.

Answer: The correct answer of the above question is Option A:Create another table to serve as a lookup for powers with fields for code and description, as well as a junction table with superhero names and power codes.