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

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

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





INSERT INTO "Cartoon" VALUES ("1", "The Adventures of Tintin", "Steven Spielberg", "1991-03-01");
INSERT INTO "Cartoon" VALUES ("2", "Tom and Jerry", "William Hanna", "1940-02-10");
INSERT INTO "Cartoon" VALUES ("3", "SpongeBob SquarePants", "Stephen Hillenburg", "1999-05-01");
INSERT INTO "Cartoon" VALUES ("4", "Rick and Morty", "Dan Harmon", "2013-12-02");
INSERT INTO "Cartoon" VALUES ("5", "Adventure Time", "Pendleton Ward", "2010-04-05");
INSERT INTO "Cartoon" VALUES ("6", "Gravity Falls", "Alex Hirsch", "2012-06-15");
INSERT INTO "Cartoon" VALUES ("7", "The Simpsons", "Matt Groening", "1989-12-17");
INSERT INTO "Cartoon" VALUES ("8", "Futurama", "Matt Groening", "1999-03-28");
INSERT INTO "Cartoon" VALUES ("9", "Avatar: The Last Airbender", "Michael Dante DiMartino", "2005-02-21");
INSERT INTO "Cartoon" VALUES ("10", "The Jetsons", "William Hanna", "1962-09-23");
INSERT INTO "Cartoon" VALUES ("11", "Tom and Jerry", "Joseph Barbera", "1940-02-10");
INSERT INTO "Cartoon" VALUES ("12", "The Powerpuff Girls", "Craig McCracken", "1998-11-18");
INSERT INTO "Cartoon" VALUES ("13", "Steven Universe", "Rebecca Sugar", "NULL");
INSERT INTO "Cartoon" VALUES ("14", "BoJack Horseman", "Raphael Bob-Waksberg", "2014-08-22");
INSERT INTO "Cartoon" VALUES ("15", "Archer", "Adam Reed", "2009-09-17");
INSERT INTO "Cartoon" VALUES ("16", "Adventure Time", "Pendleton Ward", "2010-04-05");
INSERT INTO "Cartoon" VALUES ("17", "Gravity Falls", "Alex Hirsch", "2012-06-15");
INSERT INTO "Cartoon" VALUES ("18", "The Simpsons", "Matt Groening", "1989-12-17");
INSERT INTO "Cartoon" VALUES ("19", "Futurama", "Matt Groening", "1999-03-28");
INSERT INTO "Cartoon" VALUES ("20", "Avatar: The Last Airbender", "Bryan Konietzko", "2005-02-21");