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 "Dogs" (
"dog_id" INT,
"owner_id" INT,
PRIMARY KEY ("dog_id"),
FOREIGN KEY ("owner_id") REFERENCES "Owners"("owner_id")
);

CREATE TABLE "Owners" (
"owner_id" INT,
"first_name" VARCHAR(50),
"last_name" VARCHAR(50),
"state" VARCHAR(20),
"email_address" VARCHAR(50),
PRIMARY KEY ("owner_id")
);

CREATE TABLE "Professionals" (
"professional_id" INT,
"state" VARCHAR(20),
"email_address" VARCHAR(50),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Owners" VALUES ("1", "Alice", "Smith", "North Carolina", "alice.smith@example.com");
INSERT INTO "Owners" VALUES ("2", "Bob", "Johnson", "South Carolina", "bob.johnson@example.com");
INSERT INTO "Owners" VALUES ("3", "Charlie", "Brown", "North Dakota", "charlie.brown@example.com");
INSERT INTO "Owners" VALUES ("4", "Diana", "Prince", "California", "diana.prince@example.com");
INSERT INTO "Owners" VALUES ("5", "Eve", "Adams", "North Carolina", "eve.adams@example.com");
INSERT INTO "Owners" VALUES ("6", "Frank", "White", "New York", "frank.white@example.com");
INSERT INTO "Owners" VALUES ("7", "Grace", "Taylor", "North Dakota", "grace.taylor@example.com");
INSERT INTO "Owners" VALUES ("8", "Henry", "Miller", "Florida", "henry.miller@example.com");
INSERT INTO "Owners" VALUES ("9", "Ivy", "Davis", "North Carolina", "ivy.davis@example.com");
INSERT INTO "Owners" VALUES ("10", "Jack", "Wilson", "South Dakota", "jack.wilson@example.com");
INSERT INTO "Dogs" VALUES ("101", "1");
INSERT INTO "Dogs" VALUES ("102", "2");
INSERT INTO "Dogs" VALUES ("103", "3");
INSERT INTO "Dogs" VALUES ("104", "4");
INSERT INTO "Dogs" VALUES ("105", "5");
INSERT INTO "Dogs" VALUES ("106", "1");
INSERT INTO "Dogs" VALUES ("107", "3");
INSERT INTO "Dogs" VALUES ("108", "9");
INSERT INTO "Dogs" VALUES ("109", "10");
INSERT INTO "Dogs" VALUES ("110", "6");
INSERT INTO "Professionals" VALUES ("1", "North Carolina", "prof1@example.com");
INSERT INTO "Professionals" VALUES ("2", "South Carolina", "prof2@example.com");
INSERT INTO "Professionals" VALUES ("3", "North Dakota", "prof3@example.com");
INSERT INTO "Professionals" VALUES ("4", "California", "prof4@example.com");
INSERT INTO "Professionals" VALUES ("5", "New York", "prof5@example.com");