Need some help on Normalization
Date: Fri, 10 Oct 2008 05:59:23 -0700 (PDT)
You identify the following attributes, in part, for the Employee entity:
Employee number (Primary key)
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