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 "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");
INSERT INTO "Courses" VALUES ("2", "History");
INSERT INTO "Courses" VALUES ("3", "Biology");
INSERT INTO "Courses" VALUES ("4", "Computer Science");
INSERT INTO "Courses" VALUES ("5", "Philosophy");
INSERT INTO "Sections" VALUES ("1", "Zoology", "Study of animals");
INSERT INTO "Sections" VALUES ("2", "Algebra", "Mathematical operations and relations");
INSERT INTO "Sections" VALUES ("3", "World History", "Historical events worldwide");
INSERT INTO "Sections" VALUES ("4", "Programming", "Introduction to programming languages");
INSERT INTO "Sections" VALUES ("5", "Ethics", "Philosophical study of morality");
INSERT INTO "Sections" VALUES ("6", "Quantum Mechanics", "Advanced physics concepts");
INSERT INTO "Sections" VALUES ("7", "Botany", "Study of plants");
INSERT INTO "Sections" VALUES ("8", "Ancient Civilizations", "Early human societies");
INSERT INTO "Sections" VALUES ("9", "Data Structures", "Organizing data efficiently");
INSERT INTO "Sections" VALUES ("10", "Logic", "Principles of valid reasoning");
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 2023");