Handling multi-valued attributes: Correct Solution

• Create another entity (table) to handle multiple instances of the repeating group. This second table is then linked to the original table with an identifier (i.e., foreign key). This solution has the following advantages:
  • no limit to the number of hobbies per member
  • no waste of disk space
  • searching becomes much easier within a column (e.g., who likes hiking?)

Previous slide

Next slide

Back to first slide

View graphic version