What are each physician's employee id and department id primarily affiliated.
select physician, department from affiliated_with where primaryaffiliation = 1