That helps but even in this example they have provided with PK.. Where in my example there is none.. What primary key can I select from my table to start with?
Thanks
This is not a home work but let's say if even it was.. What is the big deal helping other who needs help. Also I have not asked for anyone to create 3NF form. Just looking for some guidance on how can I create 3NF. Hope that makes sense.
I have tried separating tables based on their dependency but was having hard time to see what table depends on what. Also there are no PK, so how to link then even if I separate. There are tons of examples on web but not providing proper definition on how to create 3NF from a table which does...
how can i convert below table into 3NF.
Name Title Office State Customer Contract
Jim Smith Associate Regional TX Ford $4
Sara White Vice Pres State NY Raytheon $2
Bill Krupp Assistant Assistant CA Google $3
Thanks,
Raj
How to identify potential primary key in below table?
Name Title Office State Customer Contract
Jim Smith Associate Regional TX Ford $4
Sara White Vice Pres State NY Raytheon $2
Bill Krupp Assistant Regional CA Google $3
Thanks.