Need some help on Normalization

You identify the following attributes, in part, for the Employee entity:

    Employee number (Primary key)
    Full name
    Phone number
    Supervisor number

What change should you make to ensure that the entity is normalized to the 1st normal form (1NF)?

1. Separate the full name into first, middle (optional), and last names.
2. Use a different primary key value.
3. Move the supervisor to a different table.
4. Separate the phone number into separate fields.

I see the table as looking like this:

*Emp # (PK)     Full name              Phone#           Supervisor#*
123                     Joe Smith              123-4567           1
888                     John Doe                555-1212           2
316                     Jack Pi                  888-8080           1
451                     Suzy Q                  457-7410           3

Anybody have any comments? Thanks is advance - is there an answer Received on Fri Oct 10 2008 - 08:01:53 CDT