#ima mnogo modeli koli no edin proizvoditel
CREATE TABLE manufactures(
    manufacturer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    established_on DATE
);

CREATE TABLE models(
    model_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    manufacturer_id INT NOT NULL,
    CONSTRAINT fk_models_manufactures FOREIGN KEY (manufacturer_id)
    REFERENCES manufactures(manufacturer_id)
);

INSERT INTO manufactures(name,established_on)
VALUES  ('BMW','1916-03-01'),
        ('Tesla','2003-01-01'),
        ('Lada','1966-05-01');

SELECT * FROM manufactures;

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);
Select * FROM models;