---

CREATE TABLE Brands
(
    Id INT IDENTITY(1,1) PRIMARY KEY,
    Name NVARCHAR(100),
    Country NVARCHAR(100)
);

CREATE TABLE Models
(
    Id INT IDENTITY(1,1) PRIMARY KEY,
    Id_Brand INT,
    Name NVARCHAR(100),
    Year INT,

    FOREIGN KEY (Id_Brand)
    REFERENCES Brands(Id)
);