title: Chain of tables, when to denormalize?
body: <p>Say TABLE-A can have one or more rows in TABLE-B, which can have one or more rows in TABLE-C, which can have one or more rows in TABLE-D ... and so on.</p>
  
  <p>Say I am at TABLE-Z and need to know details about TABLE-A. Do I make a SQL query that works from TABLE-Z all the way to TABLE-A? At some point, maybe it would be nice if, say, TABLE-Z had a FK to TABLE-A so that querying won't be so painful. However, if I put that FK, I think I would be breaking normalization, right?</p>
  
  <p>General advice on how to deal with this?</p>