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 "Addresses" (
"address_id" INT,
"line_1" VARCHAR(255),
"city" VARCHAR(255),
PRIMARY KEY ("address_id")
);

CREATE TABLE "Departments" (
"department_id" INT,
"department_name" VARCHAR(255),
PRIMARY KEY ("department_id")
);

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





INSERT INTO "Addresses" VALUES ("1", "123 Maple St", "Springfield");
INSERT INTO "Addresses" VALUES ("2", "456 Oak Ave", "Shelbyville");
INSERT INTO "Addresses" VALUES ("3", "789 Pine Rd", "Ogdenville");
INSERT INTO "Addresses" VALUES ("4", "101 Elm St", "North Haverbrook");
INSERT INTO "Addresses" VALUES ("5", "202 Birch Blvd", "Capital City");
INSERT INTO "Departments" VALUES ("1", "Computer Science");
INSERT INTO "Departments" VALUES ("2", "Mathematics");
INSERT INTO "Departments" VALUES ("3", "Physics");
INSERT INTO "Departments" VALUES ("4", "History");
INSERT INTO "Departments" VALUES ("5", "English");
INSERT INTO "Students" VALUES ("1", "Timmothy", "Ward", "555-123-4567");
INSERT INTO "Students" VALUES ("2", "Timothy", "Ward", "555-987-6543");
INSERT INTO "Students" VALUES ("3", "Timmothy", "Warde", "555-222-3333");
INSERT INTO "Students" VALUES ("4", "Timmothy", "Ward", "555-000-1111");
INSERT INTO "Students" VALUES ("5", "Thomas", "Ward", "555-444-5555");
INSERT INTO "Students" VALUES ("6", "Timmothy", "Smith", "555-666-7777");