Question: What steps do you need to take to normalize the table from this diagram?
- 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.
- Add a column to this table to serve as a record identifier, and make it the primary key.
- Extend this table to have additional columns "power4," "power5," and so on, to allow additional powers for each superhero.
- 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.