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 "Students" (
"student_id" INT,
"first_name" VARCHAR(80),
"middle_name" VARCHAR(40),
"last_name" VARCHAR(40),
"cell_mobile_number" VARCHAR(40),
"email_address" VARCHAR(40),
"ssn" VARCHAR(40),
PRIMARY KEY ("student_id")
);





INSERT INTO "Students" VALUES ("1", "Timmothy", "J", "Ward", "555-123-4567", "timmothy.ward@example.com", "123-45-6789");
INSERT INTO "Students" VALUES ("2", "Alice", "M", "Smith", "555-987-6543", "alice.smith@example.com", "987-65-4321");
INSERT INTO "Students" VALUES ("3", "Timmothy", "A", "Johnson", "555-111-2222", "timmothy.johnson@example.com", "111-22-3333");
INSERT INTO "Students" VALUES ("4", "Robert", "L", "Ward", "555-333-4444", "robert.ward@example.com", "444-55-6666");
INSERT INTO "Students" VALUES ("5", "Timmothy", "NULL", "Ward", "555-777-8888", "timmothy.ward2@example.com", "777-88-9999");
INSERT INTO "Students" VALUES ("6", "Sarah", "B", "Davis", "555-000-1111", "sarah.davis@example.com", "000-11-2222");
INSERT INTO "Students" VALUES ("7", "Timmothy", "P", "Miller", "555-222-3333", "timmothy.miller@example.com", "222-33-4444");
INSERT INTO "Students" VALUES ("8", "John", "D", "Ward", "555-444-5555", "john.ward@example.com", "555-66-7777");
INSERT INTO "Students" VALUES ("9", "Emily", "R", "Brown", "555-666-7777", "emily.brown@example.com", "666-77-8888");
INSERT INTO "Students" VALUES ("10", "Timmothy", "K", "Ward", "555-999-0000", "timmothy.ward3@example.com", "999-00-1111");