Question: How do i turn the table below into third normal form, the text book im reading is somewhat helpful but im still confused on how

How do i turn the table below into third normal form, the text book im reading is somewhat helpful but im still confused on how to divide the table up and what to use as a secondary primary key. I would like to see what the table looks like in second normal form as well, that way i can get a better idea of how it breaks down.

Fname

Lname

SSN

Bdate

Address

Sex

Salary

Pname

Pnumber

Hours

Jason

Smith

123-45-6789

02/12/1978

569 Main st.

M

60,000

Project1

P0001

45

Jason

Smith

123-45-6789

02/12/1978

569 Main st.

M

60,000

Project3

P0003

67

Mark

Johnson

341-04-8745

06/30/1956

876 Oak Ave.

F

89,000

Project7

P0007

12

Lee

Navathe

672-23-9375

12/22/1980

1234 Moon blv.

M

46,000

Project1

P0001

50

Lee

Navathe

672-23-9375

12/22/1980

1234 Moon blv.

M

46,000

Project15

P00015

139

Lee

Navathe

672-23-9375

12/22/1980

1234 Moon blv.

M

46,000

Project7

P0007

21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!