Can anyone help me convert this database to 3nf?

Question

ID – unique ID# for each employee

Name – Last,First,Initial

Address

City

State

Zip

Phone

SSN

Job Skill 1: If any, ID#, Name, Proficiency (numeric code)

Job Skill 2: If any, ID#, Name, Proficiency (numeric code)

Job Skill 3: If any, ID#, Name, Proficiency (numeric code)

Pay Code – letter code: Salary Hourly Commission

Pay Rate – numeric base pay rate

Department ID

Department Name

Department Head

Answer 1

Here you go :

http://www.geekgirls.com/databases_from_...

Take it from the geek girls - they really know how to normalize a database! And think of all the fun you will have learning...

Answer 2

Job skills are duplicated.  Pay information is duplicated.  Department info is duplicated.

Answer 3

Each column must provide information about the key, the whole key and nothing but the key (so help me Codd).

So yeah, you have a boatload of normalization issues here.

1. The name column should be 3 columns. First, Last, Middle (middle initial if you prefer)

2. Job skills are all screwed up. What if someone has 4? It should be a table all in and of itself. In the seperate table, link the employee by their ID to a skill. Available skills should also be defined in a different table. Job skills may have something to do with the key, but repeating columns violates 1nf.

3. Pay code should like to another table, where each code is linked to the actual Pay (S: Salary, H:Hourly and so on.)

4. Department ID is all you need. Name and Head should be in a separate table, with ID being the join.

That should get you moving in the right direction...read over some more reference material to get it all right though.