CREATE TABLE Beers(
beer_id INT,
beer_name CHAR (64) PRIMARY KEY,
manufacturer CHAR (64));

CREATE TABLE Bars(
bar_id INT,
bar_name CHAR (64) PRIMARY KEY,
address CHAR (64));


CREATE TABLE Sells(
beer char(64),
bar char(64),
price REAL,
PRIMARY KEY (bar, beer),
FOREIGN KEY (bar) REFERENCES Bars(bar_name),
FOREIGN KEY (beer) REFERENCES Beers(beer_name));