I asked a question last week about normalizing and that brings up another point, do I even NEED to normalize the tables further.

The tables include user, building, client. (I am using MySQL).

Each of those tables has the same address components - address1, address 2, city, state, and zip.

My thought is in order to follow normalizing standards, I need to have an address table with the following fields; address_ID, address1, address 2, city, state, and zip. Then user, building, client would have a field address_ID.

And the tables, user, building, client, would each have an address_ID.

I am trying to balance keeping the PHP code simple for editing the tables and the need to normalizem the tables.

Your thoughts are MUCH appreciated!