Q2a
Note 1: The ADV_LASTNAME is not a determinant of ADV_OFFICE or ADV_PHONE, because there are
(potentially) many advisors who have the same last name.
Note 2: ADV_OFFICE is a determinant of ADV_BUILDING if the ADV_OFFICE is , in effect, a code. For
example, if offices such as HE-201 and HE-324 use the prefix HE to indicate their location in the Heinz
building, the office locators determine the building.