BD Union

create database Name
use Name

CREATE TABLE tblEmployee
(
  Id int Primary Key,
  Name nvarchar(30),
  Gender nvarchar(10),
  DepartmentId int
)
go

alter table tblEmployee
add constraint fk_tblEmployee
foreign key (DepartmentId)references  tblDepartment(DeptId)
go


drop constraint fk_tblEmployee
CREATE TABLE tblDepartment
(
 DeptId int Primary Key,
 DeptName nvarchar(20)
)

Insert into tblDepartment values (1,'IT')
Insert into tblDepartment values (2,'Payroll')
Insert into tblDepartment values (3,'HR')
Insert into tblDepartment values (4,'Admin')

Insert into tblEmployee values (1,'John', 'Male', 3)
Insert into tblEmployee values (2,'Mike', 'Male', 2)
Insert into tblEmployee values (3,'Pam', 'Female', 1)
Insert into tblEmployee values (4,'Todd', 'Male', 4)
Insert into tblEmployee values (5,'Sara', 'Female', 1)
Insert into tblEmployee values (6,'Ben', 'Male', 3)

select * from tblEmployee


delete from tblEmployee where Id=11
create view Vw_Dep
as
select  Id, Name, Gender, DeptName
from tblEmployee
inner join tblDepartment
on tblEmployee.DepartmentId = tblDepartment.DeptId