SELECT dct.pretty_name, dd.department_key FROM dotlrn_departments dd, dotlrn_community_types dct WHERE dct.community_type=dd.department_key