CREATE TABLE Foods 
(ProductCode CHAR (5) PRIMARY KEY, ProductName CHAR (20), Price FLOAT, SupplierID CHAR(6), Stock INT);

CREATE TABLE Suppliers(
SupplierID CHAR(6) PRIMARY KEY, SupplierName CHAR(20), SupplierEmail CHAR(30));

INSERT INTO foods VALUES("1239T", "Baked beans", 0.34, "S121/A", 154);
INSERT INTO foods VALUES("1237T", "Tomato soup", 0.56, "S121/A", 450);
INSERT INTO foods VALUES("1309T", "Spaghetti hoops", 0.80, "S121/A", 99);
INSERT INTO foods VALUES("4550F", "Oven chips", 1.24, "S234/F", 550);
INSERT INTO foods VALUES("3444F", "Fish fingers", 1.45, "S234/F", 756);
INSERT INTO foods VALUES("3952T", "Baked beans", 0.54, "S009/C", 17);
INSERT INTO foods VALUES("2121G", "Frankfurters", 1.02, "S009/C", 52);
INSERT INTO foods VALUES("5544C", "Sausage rolls", 2.45, "S100/C", 150);

INSERT INTO suppliers VALUES("S121/A", "Williamsons Ltd", "orders@williamson.com");
INSERT INTO suppliers VALUES("S234/F", "Artic Foods", "orders@aff.co.uk");
INSERT INTO suppliers VALUES("S009/C", "A Taste of Germany", "weissrock@dtv.de");
INSERT INTO suppliers VALUES("S100/C", "Smiths Pork Products", "oaadam@smith.com");