Re: Need some help on Normalization

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sat, 11 Oct 2008 15:16:44 -0700 (PDT)
Message-ID: <577c2056-d833-4c60-8015-7abe3a183ef8@e2g2000hsh.googlegroups.com>


On Oct 10, 9:01 am, 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

Sounds like homework to me.

What do you think 1NF, 2NF and 3NF are exactly?

How about 1nf specifically?

Anything about atomic values and/or repeating groups? Received on Sat Oct 11 2008 - 17:16:44 CDT

Original text of this message