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

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

CREATE TABLE "Semesters" (
"semester_id" INT,
"semester_name" VARCHAR(255),
PRIMARY KEY ("semester_id")
);





INSERT INTO "Courses" VALUES ("1", "Mathematics", "Study of numbers and shapes");
INSERT INTO "Courses" VALUES ("2", "History", "Study of past events");
INSERT INTO "Courses" VALUES ("3", "Biology", "Study of living organisms");
INSERT INTO "Courses" VALUES ("4", "Computer Science", "Study of computation and information");
INSERT INTO "Courses" VALUES ("5", "Physics", "Study of matter and energy");
INSERT INTO "Sections" VALUES ("1", "a", "Section for beginners");
INSERT INTO "Sections" VALUES ("2", "b", "Intermediate section");
INSERT INTO "Sections" VALUES ("3", "c", "Advanced section");
INSERT INTO "Sections" VALUES ("4", "h", "Honors section with extra projects");
INSERT INTO "Sections" VALUES ("5", "d", "Section for remedial students");
INSERT INTO "Sections" VALUES ("6", "e", "Evening section");
INSERT INTO "Sections" VALUES ("7", "f", "Weekend section");
INSERT INTO "Sections" VALUES ("8", "g", "Section for exchange students");
INSERT INTO "Semesters" VALUES ("1", "Fall 2023");
INSERT INTO "Semesters" VALUES ("2", "Spring 2024");
INSERT INTO "Semesters" VALUES ("3", "Summer 2024");
INSERT INTO "Semesters" VALUES ("4", "Winter 2024");