Turn Table Third Normal Form Text Book Im Reading Somewhat Helpful Im Still Confused Divid Q24018136

How do i turn the table below into third normal form, the textbook im reading is somewhat helpful but im still confused on how todivide the table up and what to use as a secondary primarykey.
I would like to see what the table looks like in second normal formas well, that way i can get a better idea of how it breaksdown.

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

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *