How to create 3NF from table

[Raj786911]

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

 

[jdraw]

Please describe the business context for these.
Also a 1 line description/definition of each.

 

[plog]

This smells like homework (which isn't bad per se) and its posted in the wrong forum (Table issue, not form).

What have you tried Raj?

 

[Raj786911]

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 not have any PK.

Thanks.

 

[Raj786911]

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.

 

[GinaWhipp]

Perhaps this will help...
http://pkirs.utep.edu/cis4365/Tutorials/Database%20Design/Normalization/tutorial%206.00400.htm

 

[Raj786911]

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

 

[GinaWhipp]

You are best assigning Autonumber as a PK, no one is going to see it and it's just to keep the record unique. (Side note, you would not use any of those existing fields as a PK.)

Hmm, is this your first database?

 

[jdraw]

Raj,
Do you know what a primary key is?
Maybe there is one hiding in your table.
If not, you could make one up (see surrogate key)

Also, there are many videos on youtube related to database concepts/design/development. I'm sure you can find examples to help you with normalization.

 

[Raj786911]

yes.. it is my first database.

 

[GinaWhipp]

Well, then, let's get you started off on the right foot (the one by Crystal is GREAT and will give you the biggest bang for you buck )...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

UtterAccess Newcomer's Reading List
http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html
Help with Normalization
http://www.access-programmers.co.uk/forums/showpost.php?p=1146957&postcount=2

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…

Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102