PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "car_names" (
"MakeId" INT,
"Model" TEXT,
PRIMARY KEY ("MakeId")
);

CREATE TABLE "cars_data" (
"Id" INT,
"Cylinders" INT,
"Edispl" FLOAT,
"Horsepower" TEXT,
PRIMARY KEY ("Id"),
FOREIGN KEY ("Id") REFERENCES "car_names"("MakeId")
);





INSERT INTO "car_names" VALUES ("1", "Toyota Camry");
INSERT INTO "car_names" VALUES ("2", "Honda Civic");
INSERT INTO "car_names" VALUES ("3", "Ford F-150");
INSERT INTO "car_names" VALUES ("4", "BMW 3 Series");
INSERT INTO "car_names" VALUES ("5", "Mercedes-Benz C-Class");
INSERT INTO "car_names" VALUES ("6", "Subaru Outback");
INSERT INTO "car_names" VALUES ("7", "Jeep Wrangler");
INSERT INTO "car_names" VALUES ("8", "Tesla Model 3");
INSERT INTO "car_names" VALUES ("9", "Chevrolet Silverado");
INSERT INTO "car_names" VALUES ("10", "Nissan Altima");
INSERT INTO "car_names" VALUES ("11", "Hyundai Elantra");
INSERT INTO "car_names" VALUES ("12", "Kia Sorento");
INSERT INTO "car_names" VALUES ("13", "Audi A4");
INSERT INTO "car_names" VALUES ("14", "Volkswagen Jetta");
INSERT INTO "car_names" VALUES ("15", "Mazda CX-5");
INSERT INTO "cars_data" VALUES ("1", "4", "2.5", "178");
INSERT INTO "cars_data" VALUES ("2", "4", "2.0", "158");
INSERT INTO "cars_data" VALUES ("3", "6", "3.5", "290");
INSERT INTO "cars_data" VALUES ("4", "6", "3.0", "255");
INSERT INTO "cars_data" VALUES ("5", "4", "2.0", "201");
INSERT INTO "cars_data" VALUES ("6", "4", "2.5", "182");
INSERT INTO "cars_data" VALUES ("7", "6", "3.6", "285");
INSERT INTO "cars_data" VALUES ("8", "0", "0.0", "283");
INSERT INTO "cars_data" VALUES ("9", "8", "5.3", "355");
INSERT INTO "cars_data" VALUES ("10", "4", "2.5", "188");
INSERT INTO "cars_data" VALUES ("11", "4", "2.0", "147");
INSERT INTO "cars_data" VALUES ("12", "6", "3.5", "281");
INSERT INTO "cars_data" VALUES ("13", "4", "2.0", "201");
INSERT INTO "cars_data" VALUES ("14", "4", "1.4", "158");
INSERT INTO "cars_data" VALUES ("15", "4", "2.5", "187");