CREATE TABLE Employees
(
ID int PRIMARY KEY,
Name VARCHAR(20)
)
INSERT INTO Employees
	VALUES (0, ‘%NO EMPLOYEE’)
INSERT INTO Employees 
	VALUES (102, 'Joe')
INSERT INTO Employees 
	VALUES (103, 'Jane')
INSERT INTO Departments
	VALUES (1999, 102)
CREATE TABLE Departments
(
ID int PRIMARY KEY,
Manager int DEFAULT 0
	FOREIGN KEY REFERENCES
	Employees(ID)
	ON DELETE SET NULL
	ON UPDATE SET DEFAULT
)

