MOLFHYK

CREATE TABLE bar
       (bar int not NULL UNIQUE,
	nom VARCHAR(35),
	adresse VARCHAR(30),
	PRIMARY KEY (bar));

CREATE TABLE sert
       (bar int references bar,
	biere VARCHAR(35),
	qte int CONSTRAINT SertQte
	CHECK (qte >= 0),
	PRIMARY KEY (bar, biere));

CREATE TABLE frequente
       (buveur VARCHAR(35),
	bar int references bar,
	PRIMARY KEY (buveur, bar));

CREATE TABLE aime
       (buveur VARCHAR(35),
	biere VARCHAR(35),
	PRIMARY KEY (buveur, biere));