Need some help on Normalization
From: Sheila <ydupree_at_gmail.com>
Date: Fri, 10 Oct 2008 05:59:23 -0700 (PDT)
Message-ID: <75c1d9fd-1f67-42a5-9cee-fe871da1399c@v39g2000pro.googlegroups.com>
Date: Fri, 10 Oct 2008 05:59:23 -0700 (PDT)
Message-ID: <75c1d9fd-1f67-42a5-9cee-fe871da1399c@v39g2000pro.googlegroups.com>
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)?
- Separate the full name into first, middle (optional), and last names.
- Use a different primary key value.
- Move the supervisor to a different table.
- 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 - 07:59:23 CDT