

---add department to emp_det

alter table emp_det
add emp_det_department varchar(50)
GO

Update emp_det  set emp_det_department = NULL
GO

---add department to wkr_det

alter table wkr_det
add wkr_det_department  varchar(50)
GO

Update wkr_det  set wkr_det_department = NULL
GO
