Query for adding data

I added an additional field called "Division" to the workstation details. I want to input a string value to that field for every workstation in my inventory. The input string needs to be based on the department that the user assigned to the workstation is in. For example:

Computer name: LAPTOP1
Assigned owner: Bob Smith
Dept. of owner: Executive

For each workstation who's owner is in the Executive department, set the value of the "Division" field to "Corporate".

I'm not sure if this is possible, but with my limited knowledge of SQL, I don't see any way to. If you could help me out, that would be great. Oh, and I also need workstations that are assigned to a department (in this case "Executive") instead of a user to be included.