Results 1 to 12 of 12
Dec 27, 2004, 12:08 #1
- Join Date
- Dec 2004
- 0 Post(s)
- 0 Thread(s)
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!