Does anyone have or know of any good books that discuss or teach normal forms in great detail. I'd like to say that im pretty good with 2NF, i'm looking for info on more advanced normalizations.
A specific normalization question: if i have three tables, call them A, B, C is it ever proper to have key relations that end up like: A<->B<->C<->A where X<->Y means that records in X are associated with records in Y through a foreign key type relation. This seems implicitly wrong, but data doesnt always seem to model itself in a tree like structure. sean peters [EMAIL PROTECTED] mysql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php