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

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

CREATE TABLE "TV_series" (
"id" FLOAT,
"Episode" TEXT,
"Rating" TEXT,
PRIMARY KEY ("id")
);





INSERT INTO "Cartoon" VALUES ("1", "Joseph Kuhr");
INSERT INTO "Cartoon" VALUES ("2", "Joseph Kuhr");
INSERT INTO "Cartoon" VALUES ("3", "Anna Smith");
INSERT INTO "Cartoon" VALUES ("4", "Joseph Kuhr");
INSERT INTO "Cartoon" VALUES ("5", "Michael Lee");
INSERT INTO "Cartoon" VALUES ("6", "Joseph Kuhr");
INSERT INTO "Cartoon" VALUES ("7", "Anna Smith");
INSERT INTO "Cartoon" VALUES ("8", "Joseph Kuhr");
INSERT INTO "Cartoon" VALUES ("9", "David Brown");
INSERT INTO "Cartoon" VALUES ("10", "Joseph Kuhr");
INSERT INTO "TV_Channel" VALUES ("ch1", "Funny Toons");
INSERT INTO "TV_Channel" VALUES ("ch2", "Kids Zone");
INSERT INTO "TV_Channel" VALUES ("ch3", "Cartoon World");
INSERT INTO "TV_Channel" VALUES ("ch4", "Animation Hub");
INSERT INTO "TV_series" VALUES ("1", "Episode 1", "8.5");
INSERT INTO "TV_series" VALUES ("2", "Episode 2", "7.9");
INSERT INTO "TV_series" VALUES ("3", "Episode 3", "9.0");
INSERT INTO "TV_series" VALUES ("4", "Episode 4", "6.8");
INSERT INTO "TV_series" VALUES ("5", "Episode 5", "8.2");
INSERT INTO "TV_series" VALUES ("6", "Episode 6", "7.5");
INSERT INTO "TV_series" VALUES ("7", "Episode 7", "8.9");
INSERT INTO "TV_series" VALUES ("8", "Episode 8", "9.1");
INSERT INTO "TV_series" VALUES ("9", "Episode 9", "7.0");
INSERT INTO "TV_series" VALUES ("10", "Episode 10", "8.3");