table relations problem 2

CREATE TABLE Models(
ModelID INT PRIMARY KEY,
Name NVARCHAR(50),
ManufacturerID INT
)

CREATE TABLE Manufacturers(
ManufacturerID INT PRIMARY KEY,
Name NVARCHAR(50),
EstablishedOn DATE
)

INSERT INTO Manufacturers VALUES
    (1, 'BMW', '07/03/1916'),
    (2, 'Tesla', '01/01/2003'),
    (3, 'Lada', '01/05/1966')

INSERT INTO Models VALUES
    (101, 'X1', 1),
    (102, 'i6', 1),
    (103, 'Model S', 2),
    (104, 'Model X', 2),
    (105, 'Model 3', 2),
    (106, 'Nova', 3)

ALTER TABLE Models
ADD CONSTRAINT FK_Models_Manufacturers FOREIGN KEY(ManufacturerID) REFERENCES Manufacturers(ManufacturerID)