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
Get step-by-step solutions from verified subject matter experts
