CREATE DATABASE Minions

COLLATE Cyrillic_General_100_CI_AI

USE Minions

CREATE TABLE Minions (
    Id  INT PRIMARY KEY NOT NULL,
    [Name] NVARCHAR(50),
    Age INT
)

CREATE TABLE Towns (
    Id  INT PRIMARY KEY NOT NULL,
    [Name] NVARCHAR(50),
)

ALTER TABLE Minions
ADD TownId INT
FOREIGN KEY (TownId) REFERENCES Towns (Id)

INSERT INTO Minions (Id, [Name], Age, TownId)
VALUES ('1', 'Kevin', '22', '1'),
('2','Bob', '15', '3'),
('3', 'Steward', '', '2')

INSERT INTO Towns (Id, [Name])
VALUES ('1', 'Sofia'),
('2', 'Plovdiv'),
('3', 'Varna')