Steven993,

You are so funny.

LOL,

Welsh

Why am I talking about performance when you are talking about normalization.

Do you not see a correlation?

Steven,

The more tables that you join the worse the performance gets.

The reason you want to pull address 1 and address 2 from the same table is because you do not...

Jeff,

I have no issues with your address solution but it requires an extra join and it can degrade performance.

If the objective is perfect normalization then go with an extra table...

I do not mean to be sarcastic but how many people have deployed a relational database beyond 3rd normal for? I could see 1 up from that but 3rd normal...

With respect to the Address Table Creation. You create a Mailing Address Table, Billing Address Table, etc...

It is customary to have an Address1 and Address2 Line when it is the same entity, for example Address Contains the Street Number and Name and Address two contains the...

Good dialogue.

Please remove post.

Thank you for your point.

As far as I know two Phase locking does not exist in SQL Server but it does exist in Oracle.

You may want to refer to the following article concerning the topic of normalization:

http://db.grussell.org/section009.html

This table is in 1st Normal Form.

Is you see something like Lession1, Lession2, or Order1, Order2, Order3, the database is in first normal form.

Then you break the take down...

Hi,

You may want to slightly rephrase your question.

Listed below is an article that describes two phase locking:

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbugen9/00000159.htm

Duplicate post, double click...

I have listed some information concerning the questions that you asked.

The definition of the following terms are as follows:

Data Warehouse: They use a Dimensial Data Model as opposed to a...