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 "Breeds" (
"breed_code" VARCHAR(10),
"breed_name" VARCHAR(80),
PRIMARY KEY ("breed_code")
);

CREATE TABLE "Dogs" (
"dog_id" INT,
"name" VARCHAR(50),
PRIMARY KEY ("dog_id")
);

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

CREATE TABLE "Professionals" (
"professional_id" INT,
"first_name" VARCHAR(50),
"last_name" VARCHAR(50),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Breeds" VALUES ("LAB", "Labrador Retriever");
INSERT INTO "Breeds" VALUES ("GSD", "German Shepherd Dog");
INSERT INTO "Breeds" VALUES ("POO", "Poodle");
INSERT INTO "Breeds" VALUES ("BEA", "Beagle");
INSERT INTO "Breeds" VALUES ("BUL", "Bulldog");
INSERT INTO "Breeds" VALUES ("DACH", "Dachshund");
INSERT INTO "Breeds" VALUES ("GOLD", "Golden Retriever");
INSERT INTO "Dogs" VALUES ("1", "Buddy");
INSERT INTO "Dogs" VALUES ("2", "Max");
INSERT INTO "Dogs" VALUES ("3", "Bella");
INSERT INTO "Dogs" VALUES ("4", "Lucy");
INSERT INTO "Dogs" VALUES ("5", "Charlie");
INSERT INTO "Dogs" VALUES ("6", "Daisy");
INSERT INTO "Dogs" VALUES ("7", "Cooper");
INSERT INTO "Dogs" VALUES ("8", "Luna");
INSERT INTO "Dogs" VALUES ("9", "Rocky");
INSERT INTO "Dogs" VALUES ("10", "Molly");
INSERT INTO "Dogs" VALUES ("11", "Oliver");
INSERT INTO "Dogs" VALUES ("12", "Sophie");
INSERT INTO "Dogs" VALUES ("13", "Jack");
INSERT INTO "Dogs" VALUES ("14", "Zoe");
INSERT INTO "Dogs" VALUES ("15", "Leo");
INSERT INTO "Dogs" VALUES ("16", "Chloe");
INSERT INTO "Dogs" VALUES ("17", "Milo");
INSERT INTO "Dogs" VALUES ("18", "Ruby");
INSERT INTO "Dogs" VALUES ("19", "Oscar");
INSERT INTO "Dogs" VALUES ("20", "Penny");
INSERT INTO "Dogs" VALUES ("21", "Sam");
INSERT INTO "Dogs" VALUES ("22", "Lily");
INSERT INTO "Dogs" VALUES ("23", "Duke");
INSERT INTO "Dogs" VALUES ("24", "Mia");
INSERT INTO "Dogs" VALUES ("25", "Bear");
INSERT INTO "Dogs" VALUES ("26", "Grace");
INSERT INTO "Dogs" VALUES ("27", "Winston");
INSERT INTO "Dogs" VALUES ("28", "Stella");
INSERT INTO "Dogs" VALUES ("29", "George");
INSERT INTO "Dogs" VALUES ("30", "Hazel");
INSERT INTO "Owners" VALUES ("1", "John", "Smith");
INSERT INTO "Owners" VALUES ("2", "Jane", "Doe");
INSERT INTO "Owners" VALUES ("3", "Michael", "Johnson");
INSERT INTO "Owners" VALUES ("4", "Emily", "Brown");
INSERT INTO "Owners" VALUES ("5", "David", "Davis");
INSERT INTO "Owners" VALUES ("6", "Sarah", "Miller");
INSERT INTO "Owners" VALUES ("7", "Chris", "Wilson");
INSERT INTO "Owners" VALUES ("8", "Jessica", "Moore");
INSERT INTO "Owners" VALUES ("9", "Daniel", "Taylor");
INSERT INTO "Owners" VALUES ("10", "Ashley", "Anderson");
INSERT INTO "Owners" VALUES ("11", "Matthew", "Thomas");
INSERT INTO "Owners" VALUES ("12", "Amanda", "Jackson");
INSERT INTO "Owners" VALUES ("13", "James", "White");
INSERT INTO "Owners" VALUES ("14", "Elizabeth", "Harris");
INSERT INTO "Owners" VALUES ("15", "Robert", "Martin");
INSERT INTO "Owners" VALUES ("16", "Laura", "Thompson");
INSERT INTO "Owners" VALUES ("17", "William", "Garcia");
INSERT INTO "Owners" VALUES ("18", "Megan", "Martinez");
INSERT INTO "Owners" VALUES ("19", "Richard", "Robinson");
INSERT INTO "Owners" VALUES ("20", "Nicole", "Clark");
INSERT INTO "Owners" VALUES ("21", "Kevin", "Lewis");
INSERT INTO "Owners" VALUES ("22", "Melissa", "Lee");
INSERT INTO "Owners" VALUES ("23", "Paul", "Walker");
INSERT INTO "Owners" VALUES ("24", "Michelle", "Hall");
INSERT INTO "Owners" VALUES ("25", "Mark", "Allen");
INSERT INTO "Owners" VALUES ("26", "Stephanie", "Young");
INSERT INTO "Owners" VALUES ("27", "Steven", "Hernandez");
INSERT INTO "Owners" VALUES ("28", "Kimberly", "King");
INSERT INTO "Owners" VALUES ("29", "Andrew", "Wright");
INSERT INTO "Owners" VALUES ("30", "Rebecca", "Lopez");
INSERT INTO "Owners" VALUES ("31", "Oliver", "Green");
INSERT INTO "Owners" VALUES ("32", "Sophie", "Baker");
INSERT INTO "Owners" VALUES ("33", "Jack", "Adams");
INSERT INTO "Owners" VALUES ("34", "Zoe", "Nelson");
INSERT INTO "Owners" VALUES ("35", "Leo", "Carter");
INSERT INTO "Owners" VALUES ("36", "Chloe", "Mitchell");
INSERT INTO "Owners" VALUES ("37", "Milo", "Perez");
INSERT INTO "Owners" VALUES ("38", "Ruby", "Roberts");
INSERT INTO "Owners" VALUES ("39", "Oscar", "Turner");
INSERT INTO "Owners" VALUES ("40", "Penny", "Phillips");
INSERT INTO "Professionals" VALUES ("1", "David", "Lee");
INSERT INTO "Professionals" VALUES ("2", "Sarah", "Chen");
INSERT INTO "Professionals" VALUES ("3", "Michael", "Wang");
INSERT INTO "Professionals" VALUES ("4", "Emily", "Kim");
INSERT INTO "Professionals" VALUES ("5", "Chris", "Davis");
INSERT INTO "Professionals" VALUES ("6", "Jessica", "Brown");
INSERT INTO "Professionals" VALUES ("7", "Daniel", "Miller");
INSERT INTO "Professionals" VALUES ("8", "Ashley", "Wilson");
INSERT INTO "Professionals" VALUES ("9", "Matthew", "Moore");
INSERT INTO "Professionals" VALUES ("10", "Amanda", "Taylor");
INSERT INTO "Professionals" VALUES ("11", "James", "Anderson");
INSERT INTO "Professionals" VALUES ("12", "Elizabeth", "Thomas");
INSERT INTO "Professionals" VALUES ("13", "Robert", "Jackson");
INSERT INTO "Professionals" VALUES ("14", "Laura", "White");
INSERT INTO "Professionals" VALUES ("15", "William", "Harris");
INSERT INTO "Professionals" VALUES ("16", "Megan", "Martin");
INSERT INTO "Professionals" VALUES ("17", "Richard", "Thompson");
INSERT INTO "Professionals" VALUES ("18", "Nicole", "Garcia");
INSERT INTO "Professionals" VALUES ("19", "Kevin", "Martinez");
INSERT INTO "Professionals" VALUES ("20", "Melissa", "Robinson");
INSERT INTO "Professionals" VALUES ("21", "Paul", "Clark");
INSERT INTO "Professionals" VALUES ("22", "Michelle", "Lewis");
INSERT INTO "Professionals" VALUES ("23", "Mark", "Lee");
INSERT INTO "Professionals" VALUES ("24", "Stephanie", "Walker");
INSERT INTO "Professionals" VALUES ("25", "Steven", "Hall");
INSERT INTO "Professionals" VALUES ("26", "Kimberly", "Allen");
INSERT INTO "Professionals" VALUES ("27", "Andrew", "Young");
INSERT INTO "Professionals" VALUES ("28", "Rebecca", "Hernandez");
INSERT INTO "Professionals" VALUES ("29", "John", "King");
INSERT INTO "Professionals" VALUES ("30", "Jane", "Wright");
INSERT INTO "Professionals" VALUES ("31", "Oliver", "Lopez");
INSERT INTO "Professionals" VALUES ("32", "Sophie", "Green");
INSERT INTO "Professionals" VALUES ("33", "Jack", "Baker");
INSERT INTO "Professionals" VALUES ("34", "Zoe", "Adams");
INSERT INTO "Professionals" VALUES ("35", "Leo", "Nelson");
INSERT INTO "Professionals" VALUES ("36", "Chloe", "Carter");
INSERT INTO "Professionals" VALUES ("37", "Milo", "Mitchell");
INSERT INTO "Professionals" VALUES ("38", "Ruby", "Perez");
INSERT INTO "Professionals" VALUES ("39", "Oscar", "Roberts");
INSERT INTO "Professionals" VALUES ("40", "Penny", "Turner");
INSERT INTO "Professionals" VALUES ("41", "Grace", "Phillips");
INSERT INTO "Professionals" VALUES ("42", "Winston", "Scott");
INSERT INTO "Professionals" VALUES ("43", "Stella", "Ramirez");
INSERT INTO "Professionals" VALUES ("44", "George", "Campbell");
INSERT INTO "Professionals" VALUES ("45", "Hazel", "Parker");