CREATE TABLE manufacturers(
	manufacturer_id INT UNIQUE ,
	name VARCHAR(20),
	established_on DATE
);

INSERT INTO manufacturers(manufacturer_id, name, established_on)
VALUES
	   (1, 'BMW', '1916-03-01'),
	   (2, 'Tesla', '2003-01-01'),
	   (3, 'Lada', '1966-05-01');

CREATE TABLE models(
	model_id INT UNIQUE ,
	name VARCHAR(20),
	manufacturer_id INT NOT NULL
);

INSERT INTO models(model_id, name, manufacturer_id)
VALUES
	   (101,'X1',1),
	   (102,'i6',1),
	   (103,'Model S',2),
	   (104,'Model X',2),
	   (105,'Model 3',2),
	   (106,'Nova',3);

ALTER TABLE manufacturers
ADD PRIMARY KEY (manufacturer_id);

ALTER TABLE models
ADD PRIMARY KEY (model_id);

ALTER TABLE models
ADD FOREIGN KEY (manufacturer_id) REFERENCES manufacturers(manufacturer_id);