What are each physician's employee id and department id primarily affiliated.
SELECT physician ,  department FROM affiliated_with WHERE primaryaffiliation  =  1
each physician's employee id refers to physician; department id primarily affiliated refers to department; primary affiliation = 1 indicates the primary affiliation status;