create database resto;
use resto;
CREATE TABLE categorie (
  numero int(11) NOT NULL,
  libelle varchar(15) NOT NULL,
  PRIMARY KEY  (numero)
) 



CREATE TABLE plat (
  code char(1) NOT NULL,
  nomPlat varchar(30) NOT NULL,
  numCategorie int(11) NOT NULL,
  PRIMARY KEY  (code),
  FOREIGN KEY(numCategorie) REFERENCES categorie(numero)
) 





INSERT INTO categorie VALUES (1, 'entrée');
INSERT INTO categorie VALUES (2, 'viande');
INSERT INTO categorie VALUES (3, 'poisson');
INSERT INTO categorie VALUES (4, 'dessert');




INSERT INTO plat VALUES ('a', 'carottes râpées', 1);
INSERT INTO plat VALUES ('b', 'oeuf dur mayonnaise', 1);
INSERT INTO plat VALUES ('c', 'poireaux vinaigrette', 1);
INSERT INTO plat VALUES ('d', 'sole', 3);
INSERT INTO plat VALUES ('e', 'boeuf carottes', 2);
INSERT INTO plat VALUES ('f', 'Crevettes', 3);
INSERT INTO plat VALUES ('g', 'tajine de poulet', 2);
INSERT INTO plat VALUES ('h', 'tomate au thon', 1);
INSERT INTO plat VALUES ('i', 'carbonnade de boeuf', 2);
INSERT INTO plat VALUES ('j', 'tarte aux cerises', 4);
INSERT INTO plat VALUES ('k', 'crème brûlée', 4);
INSERT INTO plat VALUES ('l', 'mousse au chocolat', 4);