Creating Tables

CREATE DATABASE SoftUni

CREATE TABLE Towns (
Id INT NOT NULL PRIMARY KEY,
Name VARCHAR(MAX) NOT NULL
)

CREATE TABLE Addresses (
Id INT NOT NULL PRIMARY KEY,
AddressText VARCHAR(MAX),
TownId INT NOT NULL FOREIGN KEY REFERENCES Towns(Id)
)

CREATE TABLE Departments (
Id INT PRIMARY KEY NOT NULL,
Name VARCHAR(MAX) NOT NULL
)

CREATE TABLE Employees (
Id INT NOT NULL PRIMARY KEY,
FirstName VARCHAR(MAX) NOT NULL,
MiddleName VARCHAR(MAX),
LastName VARCHAR(MAX) NOT NULL,
JobTitle VARCHAR(MAX) NOT NULL,
DepartmentId INT NOT NULL,
HireDate DATE,
Salary money,
AddressID INT FOREIGN KEY REFERENCES Addresses (Id)
)