SQLite format 3@ S + ?indexsqlite_autoindex_Serves_1Serves *#tableFrequentsFrequentsCREATE TABLE Frequents(drinker VARCHAR(20) NOT NULL REFERENCES Drinker(name), bar VARCHAR(20) NOT NULL REFERENCES Bar(name), times_a_week SMALLINT CHECK(times_a_week > 0), PRIMARY KEY(drinker, bar))1Eindexsqlite_autoindex_Frequents_1Frequents WtableDrinkerDrinkerCREATE TABLE Drinker(name VARCHAR(20) NOT NULL PRIMARY KEY, address VARCHAR(20))-Aindexsqlite_autoindex_Drinker_1DrinkersItableBeerBeerCREATE TABLE Beer(name VARCHAR(20) NOT NULL PRIMARY KEY, brewer VARCHAR(20))';indexsqlite_autoindex_Beer_1BeerpGtableBarBarCREATE TABLE Bar(name VARCHAR(20) NOT NULL PRIMARY KEY, address VARCHAR(20))%9indexsqlite_autoindex_Bar   MtM%-1Talk of the Town108 E. Main Street!%1Satisfaction905 W. Main Street$+1James Joyce Pub912 W. Main Street/The Edge108 Morris Street#)1Down Under Pub802 W. Main Street -Talk of the Town%Satisfaction+James Joyce Pub The Edge)Down Under Pub ZyZ/Full SailFull Sail Brewing1ErdingerErdinger Weissbrau'DixieDixie Brewing%CoronaGrupo Modelo3BudweiserAnheuser-Busch Inc.)AmstelAmstel Brewery  Full Sail Erdinger Dixie Corona Budweiser Amstel ~~1Eve100 W. Main Street1Dan300 N. Duke Street1Coy200 S. Duke Street1Ben101 W. Main Street1Amy100 W. Main Street EveDanCoyBenAmy t\J1 +EveJames Joyce Pub -DanTalk of the Town %DanSatisfaction +DanJames Joyce PubDanThe Edge)DanDown Under PubCoyThe Edge)CoyDown Under Pub-BenTalk of the Town%BenSatisfaction+BenJames Joyce Pub+AmyJames Joyce Pub zc:% R+EveJames Joyce Pub -DanTalk of the Town %DanSatisfaction +DanJames Joyce Pub DanThe Edge)DanDown Under PubCoyThe Edge)CoyDown Under Pub-BenTalk of the Town%BenSatisfaction+BenJames Joyce Pub+AmyJames Joyce Pub cN2lM*%-Talk of the TownBudweiser@"-Talk of the TownAmstel@!%SatisfactionFull Sail@%SatisfactionDixie@ %SatisfactionCorona@! %SatisfactionBudweiser@ %SatisfactionAmstel@# +James Joyce PubErdinger@  +James Joyce PubDixie!+James Joyce PubCorona@ +James Joyce PubAmstelThe EdgeCoronaThe EdgeBudweiser@The EdgeAmstel@)Down Under PubCorona#)Down Under PubBudweiser@ )Down Under PubAmstel@ KU: jKp-Talk of the TownBudweiser-Talk of the TownAmstel%SatisfactionFull Sail%SatisfactionDixie%SatisfactionCorona %SatisfactionBudweiser %SatisfactionAmstel +James Joyce PubErdinger +James Joyce PubDixie +James Joyce PubCorona+James Joyce PubAmstelThe EdgeCoronaThe EdgeBudweiserThe EdgeAmstel)Down Under PubCorona)Down Under PubBudweiser)Down Under PubAmstel )Pq+ ?indexsqlite_autoindex_Serves_1Serves *pGtableBarBarCREATE TABLE Bar(name VARCHAR(20) NOT NULL PRIMARY KEY, address VARCHAR(20))%9indexsqlite_autoindex_Bar_1BarsItableBeerBeerCREATE TABLE Beer(name VARCHAR(20) NOT NULL PRIMARY KEY, brewer VARCHAR(20))';indexsqlite_autoindex_Beer_1BeerWtableDrinkerDrinkerCREATE TABLE Drinker(name VARCHAR(20) NOT NULL PRIMARY KEY, address VARCHAR(20))-Aindexsqlite_autoindex_Drinker_1Drinker*#tableFrequentsFrequentsCREATE TABLE Frequents(drinker VARCHAR(20) NOT NULL REFERENCES Drinker(name), bar VARCHAR(20) NOT NULL REFERENCES Bar(name), times_a_week SMALLINT CHECK(times_a_week > 0), PRIMARY KEY(drinker, bar))1Eindexsqlite_autoindex_Frequents_1Frequents  etableServesServes CREATE TABLE Serves(bar VARCHAR(20) NOT NULL REFERENCES Bar(name),  etableServesServes CREATE TABLE Serves(bar VARCHAR(20) NOT NULL REFERENCES Bar(name), beer VARCHAR(20) NOT NULL REFERENCES Beer(name), price DECIMAL(5,2) CHECK(price > 0), PRIMARY KEY(bar, beer))+ ?indexsqlite_autoindex_Serves_1Serves S tableLikesLikesCREATE TABLE Likes(drinker VARCHAR(20) NOT NULL REFERENCES Drinker(name), beer VARCHAR(20) NOT NULL REFERENCES Beer(name), PRIMARY KEY(drinker, beer))) =indexsqlite_autoindex_Likes_1LikesC''viewRA_TMP_VIEW_3RA_TMP_VIEW_3CREATE VIEW RA_TMP_VIEW_3 AS SELECT DISTINCT * FROM Frequents~''9viewRA_TMP_VIEW_4RA_TMP_VIEW_4CREATE VIEW RA_TMP_VIEW_4 AS SELECT * FROM RA_TMP_VIEW_3 WHERE bar = 'James Joyce Pub'`''viewRA_TMP_VIEW_8RA_TMP_VIEW_8CREATE VIEW RA_TMP_VIEW_8 AS SELECT DISTINCT * FROM Likes R~n`R EveCorona EveAmstel DanErdinger DanDixie DanCoronaDanBudweiser DanAmstel CoyDixieBenBudweiser BenAmstel AmyCorona AmyAmstel FudUFEveCorona EveAmstel DanErdinger DanDixie DanCoronaDanBudweiserDanAmstel CoyDixieBenBudweiserBenAmstelAmyCoronaAmyAmstel:{\^''viewRA_TMP_VIEW_8RA_TMP_VIEW_8CREATE VIEW RA_TMP_VIEW_8 AS SELECT DISTINCT * FROM Likes''CviewRo))viewRA_TMP_VIEW_10RA_TMP_VIEW_10CREATE VIEW RA_TMP_VIEW_10 AS SELECT DISTINCT beer FROM RA_TMP_VIEW_9|''9viewRA_TMP_VIEW_4RA_TMP_VIEW_4CREATE VIEW RA_TMP_VIEW_4 AS SELECT * FROM RA_TMP_VIEW_3 WHERE bar = 'James Joyce Pub'{c''viewRA_TMP_VIEW_5RA_TMP_VIEW_5CREATE VIEW RA_TMP_VIEW_5 AS SELECT DISTINCT drinker FROM RA_TMP_VIEW_4{''viewRA_TMP_VIEW_6RA_TMP_VIEW_6CREATE VIEW RA_TMP_VIEW_6 AS SELECT "drinker" AS name FROM RA_TMP_VIEW_5{''CviewRA_TMP_VIEW_7RA_TMP_VIEW_7CREATE VIEW RA_TMP_VIEW_7 AS SELECT * FROM RA_TMP_VIEW_2 EXCEPT SELECT * FROM RA_TMP_VIEW_6^''viewRA_TMP_VIEW_8RA_TMP_VIEW_8CREATE VIEW RA_TMP_VIEW_8 AS SELECT DISTINCT * FROM Likes''EviewRA_TMP_VIEW_9RA_TMP_VIEW_9CREATE VIEW RA_TMP_VIEW_9 AS SELECT * FROM RA_TMP_VIEW_7, RA_TMP_VIEW_8 WHERE drinker = name