Listing 1: DDL to Create and Populate Employee and Relationship Tables
CREATE TABLE Employee (
	EmployeeID int NOT NULL CONSTRAINT Employee_PK PRIMARY KEY CLUSTERED,
	FirstName varchar (50)  NULL ,
	Surname varchar (50) NULL ,
	DateOfBirth datetime NULL ,
	DateOfJoining datetime NULL )

CREATE TABLE Relationship
(	ReportsToEmployeeID int NOT NULL ,
	EmployeeID int NOT NULL ,
	DateRelationshipEstablished datetime NULL
	CONSTRAINT Relationship_PK1 PRIMARY KEY  CLUSTERED
	(ReportsToEmployeeID,EmployeeID)
	CONSTRAINT Employee_Relationship_FK1 FOREIGN KEY
	(ReportsToEmployeeID) REFERENCES Employee
		(EmployeeID),
	CONSTRAINT Employee_Relationship_FK2 FOREIGN KEY
	(EmployeeID) REFERENCES Employee
		(EmployeeID) )

	INSERT Employee (EmployeeID,FirstName) VALUES (1,'Fred')
	INSERT Employee (EmployeeID,FirstName) VALUES (2,'Bert')
	INSERT Employee (EmployeeID,FirstName) VALUES (3,'Jack')
	INSERT Employee (EmployeeID,FirstName) VALUES (4,'Donna')
	INSERT Employee (EmployeeID,FirstName) VALUES (5,'Yvonne')
	INSERT Employee (EmployeeID,FirstName) VALUES (6,'Jill')
	INSERT Employee (EmployeeID,FirstName) VALUES (7,'Karen')
	INSERT Employee (EmployeeID,FirstName) VALUES (8,'Charles')

	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (1,1)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (2,1)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (3,1)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (4,1)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (5,3)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (6,3)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (7,4)
	INSERT Relationship (EmployeeID,ReportsToEmployeeID) VALUES (8,7)