Regrettably, the entity-relationship (ER) diagrams for the SQL programming exercise (PEX) were omitted from the assignment description. That oversight has been corrected and having the ER diagrams should make writing the queries much easier.