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 "Cartoon" (
"id" FLOAT,
"Title" TEXT,
PRIMARY KEY ("id")
);

CREATE TABLE "TV_Channel" (
"id" TEXT,
"series_name" TEXT,
"Hight_definition_TV" TEXT,
"Package_Option" TEXT,
PRIMARY KEY ("id")
);

CREATE TABLE "TV_series" (
"id" FLOAT,
"Episode" TEXT,
"Channel" TEXT,
PRIMARY KEY ("id"),
FOREIGN KEY ("Channel") REFERENCES "TV_Channel"("id")
);





INSERT INTO "Cartoon" VALUES ("1.0", "Tom and Jerry");
INSERT INTO "Cartoon" VALUES ("2.0", "Looney Tunes");
INSERT INTO "Cartoon" VALUES ("3.0", "Scooby-Doo");
INSERT INTO "Cartoon" VALUES ("4.0", "The Flintstones");
INSERT INTO "Cartoon" VALUES ("5.0", "The Simpsons");
INSERT INTO "Cartoon" VALUES ("6.0", "Family Guy");
INSERT INTO "Cartoon" VALUES ("7.0", "South Park");
INSERT INTO "Cartoon" VALUES ("8.0", "Rick and Morty");
INSERT INTO "TV_Channel" VALUES ("CH001", "Cartoon Network", "Yes", "Kids Pack");
INSERT INTO "TV_Channel" VALUES ("CH002", "Nickelodeon", "No", "Family Pack");
INSERT INTO "TV_Channel" VALUES ("CH003", "Disney Channel", "Yes", "Premium Pack");
INSERT INTO "TV_Channel" VALUES ("CH004", "Adult Swim", "Yes", "Adult Pack");
INSERT INTO "TV_Channel" VALUES ("CH005", "Discovery Channel", "No", "Documentary Pack");
INSERT INTO "TV_Channel" VALUES ("CH006", "HBO", "Yes", "Premium Pack");
INSERT INTO "TV_Channel" VALUES ("CH007", "AMC", "No", "Standard Pack");
INSERT INTO "TV_Channel" VALUES ("CH008", "FX", "Yes", "Entertainment Pack");
INSERT INTO "TV_Channel" VALUES ("CH009", "BBC America", "Yes", "International Pack");
INSERT INTO "TV_Channel" VALUES ("CH010", "PBS", "No", "Basic Pack");
INSERT INTO "TV_series" VALUES ("101.0", "The Amazing World of Gumball", "CH001");
INSERT INTO "TV_series" VALUES ("102.0", "SpongeBob SquarePants", "CH002");
INSERT INTO "TV_series" VALUES ("103.0", "Phineas and Ferb", "CH003");
INSERT INTO "TV_series" VALUES ("104.0", "Rick and Morty", "CH004");
INSERT INTO "TV_series" VALUES ("105.0", "Planet Earth", "CH005");
INSERT INTO "TV_series" VALUES ("106.0", "Game of Thrones", "CH006");
INSERT INTO "TV_series" VALUES ("107.0", "The Walking Dead", "CH007");
INSERT INTO "TV_series" VALUES ("108.0", "Atlanta", "CH008");
INSERT INTO "TV_series" VALUES ("109.0", "Killing Eve", "CH009");
INSERT INTO "TV_series" VALUES ("110.0", "Downton Abbey", "CH010");
INSERT INTO "TV_series" VALUES ("111.0", "Adventure Time", "CH001");
INSERT INTO "TV_series" VALUES ("112.0", "The Loud House", "CH002");
INSERT INTO "TV_series" VALUES ("113.0", "Gravity Falls", "CH003");
INSERT INTO "TV_series" VALUES ("114.0", "Robot Chicken", "CH004");
INSERT INTO "TV_series" VALUES ("115.0", "Blue Planet II", "CH005");
INSERT INTO "TV_series" VALUES ("116.0", "Westworld", "CH006");
INSERT INTO "TV_series" VALUES ("117.0", "Better Call Saul", "CH007");
INSERT INTO "TV_series" VALUES ("118.0", "Fargo", "CH008");
INSERT INTO "TV_series" VALUES ("119.0", "Doctor Who", "CH009");
INSERT INTO "TV_series" VALUES ("120.0", "Sesame Street", "CH010");