Re: Need some help on Normalization

From: Palooka <nobody_at_nowhere.com>
Date: Sat, 11 Oct 2008 19:53:17 +0100
Message-ID: <nC6Ik.16152$214.11566@newsfe03.ams2>


Sheila 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
E) Not take the time or trouble to attempt to read up, understand the issue and formulate an answer; just post the homework question on a usenet group instead.

Palooka Received on Sat Oct 11 2008 - 13:53:17 CDT

Original text of this message