Steps  Create the required tables Employees and department as given in script create the as string and run it using Exec( ) function Required Output create table Department ( DepartmentID int primary key identity , DepartmentName varchar …