April 25, 2007 at 11:10 pm
On the AdventureWorks database they have a person.address table, and for purchasing.vendors and humanresources.employees tables they both have a table with in there schema that is of form purchasing.VendorAddress and humanresources.EmployeeAddress that there index if made up the primary key of the person.address table.
What is the name for this type of design? Which seems to be reather nice due to the fact that one can isolate a schema and look at it as some sort of single entity while all the address data is in one table. Is this also a type of look up table?? I guess they are just many to many but I think they might be more meaningfully than that ... this is why i am asking..
thanks for any help...
erik
Dam again!
April 26, 2007 at 9:27 am
Here is the word that I am looking for Normalization.
Here is a resource for this subject:
http://databases.about.com/od/specificproducts/a/normalization.htm
seems much clearer now..
erik
Dam again!
April 28, 2007 at 9:45 pm
you might benefit from reading this:
http://www.datamodel.org/NormalizationRules.html
---------------------------------------
elsasoft.org
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply