According to praxis or expirience, when one should normalize a table in
parent-child tables related via PK-FK? What is the perecentage of
redundancy of data in a table column when that table should be
normalized in new related tables?
For example, if you have "Customer" table with column "Street"
representing only the part of customer's address, there could be more
rows with the same street but this is not so often and that column
shouldn't be reformed in new table. So, what is the threshold when
column with redundant data should be reformed in new child table?
--
Stjepan Brbot
Received on Wed Jul 24 2002 - 01:43:59 CDT
