Modeling Question

From: Steve Lucord <steve.a.lucord_at_lmco.com>
Date: Thu, 16 Dec 1999 10:05:10 -0600
Message-ID: <38590DB6.BDF479BF@lmco.com>

I have several tables that contain address information in the system I am currently working on. Instead of putting the columns that pertain to

the address in each table, I created an address table with a system assigned key. Each database table that needs an address contains a foreign key to the seperate address table.

For example:

CLIENT

Social Security VARCHAR2(11)     555-55-5555
Address_Id    NUMBER(15)        1
Name              VARCHAR2(30)     Joe Client

ADDRESS

Address_Id        NUMBER(15)        1
Address_Line    VARCHAR(80)      123 Address Way
City                   VARCHAR(30)      Any City
State                  VARCHAR(2)       AK
Zip Code            VARCHAR(10)     77598-5339

I am looking for the pros-and-cons of modeling the database in this manner. Philosophical as well as practical arguments are welcome.

Thanks in advance for any suggestions.

Steve Lucord Received on Thu Dec 16 1999 - 10:05:10 CST