Answer:
Step 1: Create 2 tables Department and Employee using below script.
/****** Object: Table [dbo].[Department] Script Date: 02-12-2015 21:50:00 ******/
SET.
ANSI_NULLS ON GO.
SET.
QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Department](
[DeptId] [int] IDENTITY(1, 1) NOT NULL,
[DeptName] [nvarchar](50) NULL,