Department Directory

Scenario

The Provost's office needs a complete list of all departments organized by school for an upcoming accreditation review.

Expected output

All 18 departments with their school affiliation, sorted by school then department code.

Tables

Hints