Know what you code
•Are the tables joined in a tree
(no loops, no missing joins)? If not, why, exactly?
•What is the direction of every
join? (Which side or sides are unique?) If any join
is many-to-many, why is it, and how can that be right?
•What is the purpose of each
join? Are you using anything from the joined-to table?