Know what you code - views
•Would the complete join diagram, which explodes the view-defining queries into the view-using query, still be a normal, clean join tree? If not, exactly what would be the corner-case behaviors of that query, and would those behaviors be correct?
•How could you code the query to base-tables, only? If the resulting base-table query would be unusual or complex, is that complexity necessary and correct?
•