View Full Version : Database Normalization


urboyfriend
10-03-2011, 01:17 AM
could i have some assistance in database normalization, im new in this thing, and btw here are the attributes.

nameID, name, addressID, address

concatinated PK ---> Table1 ---> nameID, addressID

Table2 ---> nameID, name

Table3 ---> addressID, address
am i doing this right? could i normalize this further? thanks for the quick replies!

MSAccessRookie
10-03-2011, 04:57 AM
could i have some assistance in database normalization, im new in this thing, and btw here are the attributes.

nameID, name, addressID, address

concatinated PK ---> Table1 ---> nameID, addressID

Table2 ---> nameID, name

Table3 ---> addressID, address
am i doing this right? could i normalize this further? thanks for the quick replies!

While I am not entirely sure of your needs and expectations, it looks like you have the basics down properly.

Table 1 contains items that could be repeated (Name and Address).
Table 2 contains Individual entries for Name Items.
Table 3 contains Individual entries for Address Items.

As long as the ID Fields in Table2 and Table3 are PKs, and Table1 contains ONLY the PKs for the entries in Table2 and Table3, you are on the right track

urboyfriend
10-04-2011, 02:16 AM
wait a minute what is the difference of PF and FK?

MSAccessRookie
10-04-2011, 03:08 AM
In general usage PK stands for Primary Key, which refers to the Key for a particular Table, and FK stands for Foreign Key, which refers to a Primary Key from a different Table.

jdraw
10-05-2011, 06:39 AM
I recommend the following site (first few topics) for information and the process of Normalization and data base design. Also, Entity relationship Diagramming is a key part of understanding the data before beginning any programming.
http://www.rogersaccesslibrary.com/forum/topic238.html