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

CREATE TABLE "Degree_Programs" (
"degree_program_id" INT,
"degree_summary_name" VARCHAR(255),
PRIMARY KEY ("degree_program_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),
"section_description" VARCHAR(255),
PRIMARY KEY ("section_id")
);





INSERT INTO "Courses" VALUES ("1", "Introduction to Programming");
INSERT INTO "Courses" VALUES ("2", "Data Structures and Algorithms");
INSERT INTO "Courses" VALUES ("3", "Database Management Systems");
INSERT INTO "Courses" VALUES ("4", "Operating Systems");
INSERT INTO "Courses" VALUES ("5", "Web Development");
INSERT INTO "Courses" VALUES ("6", "Calculus I");
INSERT INTO "Courses" VALUES ("7", "Linear Algebra");
INSERT INTO "Courses" VALUES ("8", "Physics I");
INSERT INTO "Courses" VALUES ("9", "Chemistry I");
INSERT INTO "Courses" VALUES ("10", "English Composition");
INSERT INTO "Degree_Programs" VALUES ("1", "Bachelor of Science in Computer Science");
INSERT INTO "Degree_Programs" VALUES ("2", "Bachelor of Arts in English");
INSERT INTO "Degree_Programs" VALUES ("3", "Master of Science in Data Science");
INSERT INTO "Degree_Programs" VALUES ("4", "Ph.D. in Electrical Engineering");
INSERT INTO "Degree_Programs" VALUES ("5", "Associate of Arts in General Studies");
INSERT INTO "Departments" VALUES ("1", "Computer Science");
INSERT INTO "Departments" VALUES ("2", "Mathematics");
INSERT INTO "Departments" VALUES ("3", "Physics");
INSERT INTO "Departments" VALUES ("4", "Chemistry");
INSERT INTO "Departments" VALUES ("5", "English");
INSERT INTO "Departments" VALUES ("6", "Electrical Engineering");
INSERT INTO "Sections" VALUES ("1", "CS101-A", "Introduction to Programming - Section A");
INSERT INTO "Sections" VALUES ("2", "CS101-B", "Introduction to Programming - Section B");
INSERT INTO "Sections" VALUES ("3", "CS201-A", "Data Structures and Algorithms - Section A");
INSERT INTO "Sections" VALUES ("4", "DB301-X", "Database Management Systems - Online Section");
INSERT INTO "Sections" VALUES ("5", "OS401-F", "Operating Systems - Fall Semester");
INSERT INTO "Sections" VALUES ("6", "WEB200-S", "Web Development - Spring Semester");
INSERT INTO "Sections" VALUES ("7", "MA101-1", "Calculus I - Lecture 1");
INSERT INTO "Sections" VALUES ("8", "PH101-L", "Physics I - Lab Section");
INSERT INTO "Sections" VALUES ("9", "EN101-W", "English Composition - Writing Workshop");
INSERT INTO "Sections" VALUES ("10", "EE500-R", "Advanced Topics in EE - Research Seminar");
INSERT INTO "Sections" VALUES ("11", "CS999-Z", "Special Topics in CS - Advanced Research");
INSERT INTO "Sections" VALUES ("12", "MA201-2", "Linear Algebra - Evening Class");
INSERT INTO "Sections" VALUES ("13", "CH101-P", "Chemistry I - Practical Session");
INSERT INTO "Sections" VALUES ("14", "DB301-Y", "Database Management Systems - Hybrid Section");
INSERT INTO "Sections" VALUES ("15", "OS401-W", "Operating Systems - Winter Session");