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 "Courses" (
"course_id" INT UNIQUE,
"course_name" VARCHAR(255),
PRIMARY KEY ("course_id")
);

CREATE TABLE "Departments" (
"department_id" INT,
"department_name" VARCHAR(255),
PRIMARY KEY ("department_id")
);

CREATE TABLE "Sections" (
"section_id" INT,
"section_name" VARCHAR(255),
PRIMARY KEY ("section_id")
);





INSERT INTO "Courses" VALUES ("101", "Introduction to Programming");
INSERT INTO "Courses" VALUES ("102", "Data Structures");
INSERT INTO "Courses" VALUES ("103", "Algorithms");
INSERT INTO "Courses" VALUES ("104", "Database Systems");
INSERT INTO "Courses" VALUES ("105", "Operating Systems");
INSERT INTO "Courses" VALUES ("106", "Web Development");
INSERT INTO "Courses" VALUES ("107", "Artificial Intelligence");
INSERT INTO "Courses" VALUES ("108", "Machine Learning");
INSERT INTO "Courses" VALUES ("109", "Computer Networks");
INSERT INTO "Courses" VALUES ("110", "Software Engineering");
INSERT INTO "Departments" VALUES ("1", "Computer Science");
INSERT INTO "Departments" VALUES ("2", "Electrical Engineering");
INSERT INTO "Departments" VALUES ("3", "Mathematics");
INSERT INTO "Departments" VALUES ("4", "Physics");
INSERT INTO "Departments" VALUES ("5", "Chemistry");
INSERT INTO "Departments" VALUES ("6", "Biology");
INSERT INTO "Departments" VALUES ("7", "English");
INSERT INTO "Departments" VALUES ("8", "History");
INSERT INTO "Departments" VALUES ("9", "Economics");
INSERT INTO "Departments" VALUES ("10", "Psychology");
INSERT INTO "Sections" VALUES ("1", "A");
INSERT INTO "Sections" VALUES ("2", "B");
INSERT INTO "Sections" VALUES ("3", "C");
INSERT INTO "Sections" VALUES ("4", "D");
INSERT INTO "Sections" VALUES ("5", "E");
INSERT INTO "Sections" VALUES ("6", "F");
INSERT INTO "Sections" VALUES ("7", "G");
INSERT INTO "Sections" VALUES ("8", "H");
INSERT INTO "Sections" VALUES ("9", "I");
INSERT INTO "Sections" VALUES ("10", "J");
INSERT INTO "Sections" VALUES ("11", "K");
INSERT INTO "Sections" VALUES ("12", "L");
INSERT INTO "Sections" VALUES ("13", "M");
INSERT INTO "Sections" VALUES ("14", "N");
INSERT INTO "Sections" VALUES ("15", "O");
INSERT INTO "Sections" VALUES ("16", "P");
INSERT INTO "Sections" VALUES ("17", "Q");
INSERT INTO "Sections" VALUES ("18", "R");
INSERT INTO "Sections" VALUES ("19", "S");
INSERT INTO "Sections" VALUES ("20", "T");