/* Database Systems, Coronel/Morris */
/* Type of SQL : Oracle */

CREATE TABLE BOOTH (
BOOTH_PRODUCT  VARCHAR2(50),
BOOTH_PRICE    NUMBER(5,2)
);

INSERT INTO BOOTH VALUES ('Chips', 1.5);
INSERT INTO BOOTH VALUES ('Cola', 1.25);
INSERT INTO BOOTH VALUES ('Energy Drink', 2);

/* -- */

CREATE TABLE MACHINE (
MACHINE_PRODUCT  VARCHAR2(50),
MACHINE_PRICE    NUMBER(5,2)
);

INSERT INTO MACHINE VALUES ('Chips', 1.25);
INSERT INTO MACHINE VALUES ('Chocolate Bar', 1);
INSERT INTO MACHINE VALUES ('Energy Drink', 2);

