IF  EXISTS (SELECT * FROM sys.objects WHERE name='Empl' AND TYPE IN (N'U'))
DROP TABLE Empl
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE name='Dept' AND TYPE IN (N'U'))
DROP TABLE Dept
GO

CREATE TABLE Empl
(
   ID  INT IDENTITY(1,1) PRIMARY KEY,
   FirstName nvarchar(20) NOT NULL,
   LastName nvarchar(20) NOT NULL,
   Salary money NOT NULL,
   DeptID INT NOT NULL
)
GO
CREATE TABLE Dept
(
   ID  INT IDENTITY(1,1)PRIMARY KEY,
   City nvarchar(20) NOT NULL
)
GO

DECLARE @dept_id INT
INSERT INTO Dept (City) VALUES ('Kiev')
SET @dept_id = @@IDENTITY
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Yan','Krilov', '8500', @dept_id)
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Olga','Alekseenko', '5555,55', @dept_id)

INSERT INTO Dept (City) VALUES ('Moscow')
SET @dept_id = @@IDENTITY
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Liza','Ivanova', '9000', @dept_id)
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Tanya','Astrahanceva', '5000', @dept_id)
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Oleg','Amur', '2323,32', @dept_id)
INSERT INTO Dept (City) VALUES ('Sevastopol')

SET @dept_id = @@IDENTITY
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Yaroslav','Ivanov', '10000', @dept_id)

INSERT INTO Dept (City) VALUES ('Odessa')
SET @dept_id = @@IDENTITY
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Sveta','Lazarenko', '3000', @dept_id)
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Anna','Anohina', '6000', @dept_id)
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Katya','Azarova', '8456,40', @dept_id)

INSERT INTO Dept (City) VALUES ('Yalta')
SET @dept_id = @@IDENTITY
INSERT INTO Empl (FirstName, LastName, Salary, DeptID) VALUES ('Jenya','Agalcova', '7000', @dept_id)

SELECT * FROM Empl
SELECT * FROM Dept
GO