[dymk]

Only if there's a separate Departments table, which for this very simple example, there isn't

[maweki]

Even if there were a separate Departments table, who is to say that the Department Name is not its primary key? The Department name certainly is A key.