text: CREATE TABLE manufacturers (
      manufacturer_id INT PRIMARY KEY AUTO_INCREMENT,
      `name` VARCHAR(50),
      established_on DATE
  );
  
  INSERT INTO manufacturers (`name`, established_on) VALUES
  ('BMW', '1916-03-01'),
  ('Tesla', '2003-01-01'),
  ('Lada', '1966-05-01');
  
  CREATE TABLE models (
      model_id INT PRIMARY KEY AUTO_INCREMENT,
      `name` VARCHAR(50),
      manufacturer_id INT
  );
  
  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 models 
  add constraint fk_models_manufacturers foreign key (manufacturer_id) references manufacturers(manufacturer_id)