• So to summarize:

    Separate (normalized) tables:

    PROS:

    - Much more flexibility in assigning phone numbers to employees.

    CONS:

    - Slightly more complicated and slightly more costly to query

    One table (denormalized):

    PROS:

    - Simpler queries

    - Slightly faster queries

    CONS:

    - Little flexibility to add new numbers (requires schema change).