|
|
Posted by Daz on 10/06/06 01:39
davie wrote:
> If you cannot join two tables it must be a flaw in your design,
>
> Normalization is the process of removing redundant data from relational
> tables by decomposing (splitting) a relational table into smaller
> tables. In order to be correct, decomposition must be lossless. That
> is, the new tables can be recombined by a natural join to recreate the
> original table without creating any spurious or redundant data. .
> I suggest you check out
> http://www.utexas.edu/its/windows/database/datamodeling/index.html
The URL will be a useful asset to the documentation I currently know
of. Thank you very much. It is undoubtably a flaw in my design. I had
given it a lot of thought previously, and I had two ideas. My ISP lets
me use a small amount of server space for free, along with some other
resources such as the MySQL database. I went with the idea that I
believed would be lower on resources. It would appear that this is the
wrong way. Anyhow, this is getting way off topic, so I will no doubt
post in the appropriate group at some point, and hope for a good
discussion. Thanks for your input, it's very much appreciated.
Best wishes.
Daz
Navigation:
[Reply to this message]
|