Pizza data

Person name	age	gender Amy	16	female Ben	21	male Cal	33	male Dan	13	male Eli	45	male Fay	21	female Gus	24	male Hil	30	female Ian	18	male

Frequents name	pizzeria Amy	Pizza Hut Ben	Chicago Pizza Ben	Pizza Hut Cal	New York Pizza Cal	Straw Hat Dan	New York Pizza Dan	Straw Hat Eli	Chicago Pizza Eli	Straw Hat Fay	Dominos Fay	Little Caesars Gus	Chicago Pizza Gus	Pizza Hut Hil	Dominos Hil	Pizza Hut Hil	Straw Hat Ian	Dominos Ian	New York Pizza Ian	Straw Hat

Eats name	pizza Amy	mushroom Amy	pepperoni Ben	cheese Ben	pepperoni Cal	supreme Dan	cheese Dan	mushroom Dan	pepperoni Dan	sausage Dan	supreme Eli	cheese Eli	supreme Fay	mushroom Gus	cheese Gus	mushroom Gus	supreme Hil	cheese Hil	supreme Ian	pepperoni Ian	supreme

Serves pizzeria	pizza	       price Chicago Pizza	cheese	       7.75 Chicago Pizza	supreme	       8.5 Dominos	       cheese	        9.75 Dominos	       mushroom	11 Little Caesars	cheese	       7 Little Caesars	mushroom	9.25 Little Caesars	pepperoni	9.75 Little Caesars	sausage	       9.5 New York Pizza	cheese	       7 New York Pizza	pepperoni	8 New York Pizza	supreme	       8.5 Pizza Hut	cheese	       9 Pizza Hut	pepperoni	12 Pizza Hut	sausage	       12 Pizza Hut	supreme	       12 Straw Hat	cheese	       9.25 Straw Hat	pepperoni	8 Straw Hat	sausage	       9.75

Regenerate Data for SQLite. /* Delete the tables if they already exist */ drop table if exists Person; drop table if exists Frequents; drop table if exists Eats; drop table if exists Serves;

/* Create the schema for our tables */ create table Person(name text, age int, gender text); create table Frequents(name text, pizzeria text); create table Eats(name text, pizza text); create table Serves(pizzeria text, pizza text, price decimal);

/* Populate the tables with our data */ insert into Person values('Amy', 16, 'female'); insert into Person values('Ben', 21, 'male'); insert into Person values('Cal', 33, 'male'); insert into Person values('Dan', 13, 'male'); insert into Person values('Eli', 45, 'male'); insert into Person values('Fay', 21, 'female'); insert into Person values('Gus', 24, 'male'); insert into Person values('Hil', 30, 'female'); insert into Person values('Ian', 18, 'male');

insert into Frequents values('Amy', 'Pizza Hut'); insert into Frequents values('Ben', 'Pizza Hut'); insert into Frequents values('Ben', 'Chicago Pizza'); insert into Frequents values('Cal', 'Straw Hat'); insert into Frequents values('Cal', 'New York Pizza'); insert into Frequents values('Dan', 'Straw Hat'); insert into Frequents values('Dan', 'New York Pizza'); insert into Frequents values('Eli', 'Straw Hat'); insert into Frequents values('Eli', 'Chicago Pizza'); insert into Frequents values('Fay', 'Dominos'); insert into Frequents values('Fay', 'Little Caesars'); insert into Frequents values('Gus', 'Chicago Pizza'); insert into Frequents values('Gus', 'Pizza Hut'); insert into Frequents values('Hil', 'Dominos'); insert into Frequents values('Hil', 'Straw Hat'); insert into Frequents values('Hil', 'Pizza Hut'); insert into Frequents values('Ian', 'New York Pizza'); insert into Frequents values('Ian', 'Straw Hat'); insert into Frequents values('Ian', 'Dominos');

insert into Eats values('Amy', 'pepperoni'); insert into Eats values('Amy', 'mushroom'); insert into Eats values('Ben', 'pepperoni'); insert into Eats values('Ben', 'cheese'); insert into Eats values('Cal', 'supreme'); insert into Eats values('Dan', 'pepperoni'); insert into Eats values('Dan', 'cheese'); insert into Eats values('Dan', 'sausage'); insert into Eats values('Dan', 'supreme'); insert into Eats values('Dan', 'mushroom'); insert into Eats values('Eli', 'supreme'); insert into Eats values('Eli', 'cheese'); insert into Eats values('Fay', 'mushroom'); insert into Eats values('Gus', 'mushroom'); insert into Eats values('Gus', 'supreme'); insert into Eats values('Gus', 'cheese'); insert into Eats values('Hil', 'supreme'); insert into Eats values('Hil', 'cheese'); insert into Eats values('Ian', 'supreme'); insert into Eats values('Ian', 'pepperoni');

insert into Serves values('Pizza Hut', 'pepperoni', 12); insert into Serves values('Pizza Hut', 'sausage', 12); insert into Serves values('Pizza Hut', 'cheese', 9); insert into Serves values('Pizza Hut', 'supreme', 12); insert into Serves values('Little Caesars', 'pepperoni', 9.75); insert into Serves values('Little Caesars', 'sausage', 9.5); insert into Serves values('Little Caesars', 'cheese', 7); insert into Serves values('Little Caesars', 'mushroom', 9.25); insert into Serves values('Dominos', 'cheese', 9.75); insert into Serves values('Dominos', 'mushroom', 11); insert into Serves values('Straw Hat', 'pepperoni', 8); insert into Serves values('Straw Hat', 'cheese', 9.25); insert into Serves values('Straw Hat', 'sausage', 9.75); insert into Serves values('New York Pizza', 'pepperoni', 8); insert into Serves values('New York Pizza', 'cheese', 7); insert into Serves values('New York Pizza', 'supreme', 8.5); insert into Serves values('Chicago Pizza', 'cheese', 7.75); insert into Serves values('Chicago Pizza', 'supreme', 8.5);