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

CREATE TABLE "Student_Enrolment" (
"student_enrolment_id" INT,
"student_id" INT,
PRIMARY KEY ("student_enrolment_id"),
FOREIGN KEY ("student_id") REFERENCES "Students"("student_id")
);

CREATE TABLE "Students" (
"student_id" INT UNIQUE,
"first_name" VARCHAR(80),
"middle_name" VARCHAR(40),
"last_name" VARCHAR(40),
"cell_mobile_number" VARCHAR(40),
"email_address" VARCHAR(40),
PRIMARY KEY ("student_id")
);





INSERT INTO "Degree_Programs" VALUES ("1", "Computer Science");
INSERT INTO "Degree_Programs" VALUES ("2", "Electrical Engineering");
INSERT INTO "Degree_Programs" VALUES ("3", "Mathematics");
INSERT INTO "Degree_Programs" VALUES ("4", "Physics");
INSERT INTO "Degree_Programs" VALUES ("5", "Chemistry");
INSERT INTO "Degree_Programs" VALUES ("6", "Biology");
INSERT INTO "Degree_Programs" VALUES ("7", "History");
INSERT INTO "Degree_Programs" VALUES ("8", "English Literature");
INSERT INTO "Degree_Programs" VALUES ("9", "Business Administration");
INSERT INTO "Degree_Programs" VALUES ("10", "Economics");
INSERT INTO "Students" VALUES ("1", "Alice", "M.", "Smith", "111-222-3333", "alice.smith@example.com");
INSERT INTO "Students" VALUES ("2", "Bob", "J.", "Johnson", "444-555-6666", "bob.johnson@example.com");
INSERT INTO "Students" VALUES ("3", "Charlie", "P.", "Brown", "777-888-9999", "charlie.brown@example.com");
INSERT INTO "Students" VALUES ("4", "Diana", "L.", "Miller", "123-456-7890", "diana.miller@example.com");
INSERT INTO "Students" VALUES ("5", "Eve", "K.", "Davis", "987-654-3210", "eve.davis@example.com");
INSERT INTO "Students" VALUES ("6", "Frank", "R.", "Garcia", "555-111-2222", "frank.garcia@example.com");
INSERT INTO "Students" VALUES ("7", "Grace", "S.", "Rodriguez", "333-444-5555", "grace.rodriguez@example.com");
INSERT INTO "Students" VALUES ("8", "Henry", "T.", "Martinez", "666-777-8888", "henry.martinez@example.com");
INSERT INTO "Students" VALUES ("9", "Ivy", "U.", "Hernandez", "999-000-1111", "ivy.hernandez@example.com");
INSERT INTO "Students" VALUES ("10", "Jack", "V.", "Lopez", "222-333-4444", "jack.lopez@example.com");
INSERT INTO "Student_Enrolment" VALUES ("1", "1");
INSERT INTO "Student_Enrolment" VALUES ("2", "1");
INSERT INTO "Student_Enrolment" VALUES ("3", "1");
INSERT INTO "Student_Enrolment" VALUES ("4", "2");
INSERT INTO "Student_Enrolment" VALUES ("5", "2");
INSERT INTO "Student_Enrolment" VALUES ("6", "3");
INSERT INTO "Student_Enrolment" VALUES ("7", "3");
INSERT INTO "Student_Enrolment" VALUES ("8", "3");
INSERT INTO "Student_Enrolment" VALUES ("9", "3");
INSERT INTO "Student_Enrolment" VALUES ("10", "4");
INSERT INTO "Student_Enrolment" VALUES ("11", "4");
INSERT INTO "Student_Enrolment" VALUES ("12", "5");
INSERT INTO "Student_Enrolment" VALUES ("13", "5");
INSERT INTO "Student_Enrolment" VALUES ("14", "5");
INSERT INTO "Student_Enrolment" VALUES ("15", "6");
INSERT INTO "Student_Enrolment" VALUES ("16", "7");
INSERT INTO "Student_Enrolment" VALUES ("17", "7");
INSERT INTO "Student_Enrolment" VALUES ("18", "8");
INSERT INTO "Student_Enrolment" VALUES ("19", "9");
INSERT INTO "Student_Enrolment" VALUES ("20", "9");
INSERT INTO "Student_Enrolment" VALUES ("21", "9");
INSERT INTO "Student_Enrolment" VALUES ("22", "10");
INSERT INTO "Student_Enrolment" VALUES ("23", "10");
INSERT INTO "Student_Enrolment" VALUES ("24", "10");
INSERT INTO "Student_Enrolment" VALUES ("25", "10");
INSERT INTO "Student_Enrolment" VALUES ("26", "10");
INSERT INTO "Student_Enrolment" VALUES ("27", "1");
INSERT INTO "Student_Enrolment" VALUES ("28", "1");
INSERT INTO "Student_Enrolment" VALUES ("29", "3");
INSERT INTO "Student_Enrolment" VALUES ("30", "3");
INSERT INTO "Student_Enrolment" VALUES ("31", "10");
INSERT INTO "Student_Enrolment" VALUES ("32", "10");
INSERT INTO "Student_Enrolment" VALUES ("33", "10");
INSERT INTO "Student_Enrolment" VALUES ("34", "10");
INSERT INTO "Student_Enrolment" VALUES ("35", "10");
INSERT INTO "Student_Enrolment" VALUES ("36", "10");
INSERT INTO "Student_Enrolment" VALUES ("37", "10");
INSERT INTO "Student_Enrolment" VALUES ("38", "10");
INSERT INTO "Student_Enrolment" VALUES ("39", "10");
INSERT INTO "Student_Enrolment" VALUES ("40", "10");