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 "evaluation" (
"Employee_ID" TEXT,
"Year_awarded" TEXT,
"Bonus" FLOAT,
PRIMARY KEY ("Employee_ID", "Year_awarded")
);

CREATE TABLE "hiring" (
"Employee_ID" INT,
PRIMARY KEY ("Employee_ID")
);

CREATE TABLE "shop" (
"Shop_ID" INT UNIQUE,
"Number_products" INT,
PRIMARY KEY ("Shop_ID")
);





INSERT INTO "evaluation" VALUES ("E001", "2020", "1500.0");
INSERT INTO "evaluation" VALUES ("E002", "2021", "2000.0");
INSERT INTO "evaluation" VALUES ("E003", "2020", "1200.0");
INSERT INTO "evaluation" VALUES ("E004", "2022", "2500.0");
INSERT INTO "evaluation" VALUES ("E005", "2021", "1800.0");
INSERT INTO "evaluation" VALUES ("E006", "2020", "1000.0");
INSERT INTO "evaluation" VALUES ("E007", "2022", "3000.0");
INSERT INTO "evaluation" VALUES ("E008", "2021", "1600.0");
INSERT INTO "evaluation" VALUES ("E009", "2020", "1300.0");
INSERT INTO "evaluation" VALUES ("E010", "2022", "2200.0");
INSERT INTO "hiring" VALUES ("101");
INSERT INTO "hiring" VALUES ("102");
INSERT INTO "hiring" VALUES ("103");
INSERT INTO "hiring" VALUES ("104");
INSERT INTO "hiring" VALUES ("105");
INSERT INTO "hiring" VALUES ("106");
INSERT INTO "hiring" VALUES ("107");
INSERT INTO "hiring" VALUES ("108");
INSERT INTO "hiring" VALUES ("109");
INSERT INTO "hiring" VALUES ("110");
INSERT INTO "shop" VALUES ("1", "50");
INSERT INTO "shop" VALUES ("2", "120");
INSERT INTO "shop" VALUES ("3", "30");
INSERT INTO "shop" VALUES ("4", "200");
INSERT INTO "shop" VALUES ("5", "80");
INSERT INTO "shop" VALUES ("6", "15");
INSERT INTO "shop" VALUES ("7", "250");
INSERT INTO "shop" VALUES ("8", "90");
INSERT INTO "shop" VALUES ("9", "45");
INSERT INTO "shop" VALUES ("10", "180");
INSERT INTO "shop" VALUES ("11", "1");
INSERT INTO "shop" VALUES ("12", "500");