PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE People (name TEXT, belt TEXT, id INTEGER PRIMARY KEY);
INSERT INTO People VALUES('Gillian Gorilla','Black',1);
INSERT INTO People VALUES('Carol Careful','Yellow',2);
INSERT INTO People VALUES('Alice Adventure','Yellow',3);
INSERT INTO People VALUES('Helen Hamster','White',4);
INSERT INTO People VALUES('Betsy Brownie','White',5);
INSERT INTO People VALUES('Ellen Eager','White',6);
INSERT INTO People VALUES('Debbie Dinosaur','Green',7);
INSERT INTO People VALUES('Faith Fantastic','Blue',8);
INSERT INTO People VALUES('Sandra Scorpion','Black',9);
INSERT INTO People VALUES('Ida Incredible','Brown',10);
INSERT INTO People VALUES('Jill Jovial','Brown',11);
INSERT INTO People VALUES('Kate Killjoy','Green',12);
INSERT INTO People VALUES('Luna Lionheart','Black',13);
INSERT INTO People VALUES('Mia Meek','White',14);
INSERT INTO People VALUES('Nancy Novice','White',15);
INSERT INTO People VALUES('Opal Outrageous','Yellow',16);
INSERT INTO People VALUES('Petunia Pipsqueak','Yellow',17);
INSERT INTO People VALUES('Queenie Quillpot','Green',18);
INSERT INTO People VALUES('Ruth Rampage','Blue',19);
INSERT INTO People VALUES('Tracy Teetotaller','Brown',20);
CREATE TABLE Dojos (name TEXT, address TEXT, sensei INTEGER, id INTEGER PRIMARY KEY);
INSERT INTO Dojos VALUES('Blue Moon Fight Club','12 Main Street',1,1);
INSERT INTO Dojos VALUES('13 Monkeys Dojo','13 State Street',13,2);
INSERT INTO Dojos VALUES('Main Street Martial Arts','52 Main Street',9,3);
CREATE TABLE StudentAt(student INTEGER, dojo INTEGER, PRIMARY KEY (student,dojo));
INSERT INTO StudentAt VALUES(2,1);
INSERT INTO StudentAt VALUES(4,1);
INSERT INTO StudentAt VALUES(11,1);
INSERT INTO StudentAt VALUES(12,1);
INSERT INTO StudentAt VALUES(7,2);
INSERT INTO StudentAt VALUES(19,2);
INSERT INTO StudentAt VALUES(16,2);
INSERT INTO StudentAt VALUES(14,2);
INSERT INTO StudentAt VALUES(3,2);
INSERT INTO StudentAt VALUES(12,2);
INSERT INTO StudentAt VALUES(18,3);
INSERT INTO StudentAt VALUES(17,3);
INSERT INTO StudentAt VALUES(15,3);
INSERT INTO StudentAt VALUES(8,3);
INSERT INTO StudentAt VALUES(5,1);
INSERT INTO StudentAt VALUES(6,2);
INSERT INTO StudentAt VALUES(10,2);
INSERT INTO StudentAt VALUES(8,1);
CREATE TABLE TeachesAt (sensei INTEGER, dojo INTEGER, schedule TEXT, PRIMARY KEY (sensei,dojo));
INSERT INTO TeachesAt VALUES(1,1,'MWF 7:00 p.m.');
INSERT INTO TeachesAt VALUES(9,3,'W 5:00 p.m., SaSu 10:00 a.m.');
INSERT INTO TeachesAt VALUES(11,1,'TTh 8:00 p.m.');
INSERT INTO TeachesAt VALUES(11,2,'MWF 9:00 p.m.');
COMMIT;