Re: Need some help on Normalization

On Oct 10, 2:01 pm, Lollie <techtechx..._at_gmail.com> wrote:
> 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)?
>
> A) Separate the full name into first, middle (optional), and last
> names.
> B) Use a different primary key value.
> C) Move the supervisor to a different table.
> D) 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

The question of how to normalise middle names is asking for trouble. What about people with with two or more middle names? That and the fact that they're optional (not to mention people with only one name) suggests PERSON NAME is a separate entity in a one to one or many relationship. Whether that is practical in a real-life database is another question. Received on Sun Oct 12 2008 - 01:41:52 CDT