 | |
#1
 
| |||
| |||
|
Need some help on Normalization -
10-10-2008
, 08:02 AM
#2
| |||
| |||
|
|
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 |
what would you guess?
/Lennart
#3
| |||
| |||
|
|
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 |
what would you guess?
/Lennart
#4
| |||
| |||
|
|
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 |
what would you guess?
/Lennart
#5
| |||
| |||
|
|
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 |
Quis custodiet ipsos custodes
that should suffice.
Bye.
Jasen
#6
| |||
| |||
|
|
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 |
Quis custodiet ipsos custodes
that should suffice.
Bye.
Jasen
#7
| |||
| |||
|
|
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 |
Quis custodiet ipsos custodes
that should suffice.
Bye.
Jasen
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.