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');