how far to normalize these tables
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!