data.sql

该代码是一个脚本

CREATE TABLE PB06210445.DISH
(FOOD# VARCHAR2(20) NOT NULL,
CUISINE VARCHAR2(20) NOT NULL,
CONSTRAINT PK_DISH PRIMARY KEY(FOOD#));

CREATE TABLE PB06210445.CALORIES
(INGREDIENT# VARCHAR2(20) NOT NULL,
QUANTITY NUMBER(8),
CALORIES NUMBER(8),
CONSTRAINT PK_CALORIES PRIMARY KEY(INGREDIENT#));

CREATE TABLE PB06210445.INGREDIENTS
(FOOD# VARCHAR2(20) NOT NULL,
INGREDIENT# VARCHAR2(20) NOT NULL,
QUANTITY NUMBER(8),
CONSTRAINT FK_DISH FOREIGN KEY(FOOD#)
REFERENCES PB06210445.DISH(FOOD#),
CONSTRAINT FK_CALORIES FOREIGN KEY(INGREDIENT#)
REFERENCES PB06210445.CALORIES(INGREDIENT#));

INSERT INTO PB06210445.DISH VALUES('FOOD1','CHINESE');
INSERT INTO PB06210445.DISH VALUES('FOOD2','INDIAN');
INSERT INTO PB06210445.DISH VALUES('FOOD3','AMERICAN');
INSERT INTO PB06210445.DISH VALUES('FOOD4','HONGKONG');
INSERT INTO PB06210445.DISH VALUES('FOOD5','INDIAN');
INSERT INTO PB06210445.DISH VALUES('FOOD6','CHINESE');
INSERT INTO PB06210445.DISH VALUES('FOOD7','JAPANESE');
INSERT INTO PB06210445.DISH VALUES('FOOD8','CANADA');
INSERT INTO PB06210445.DISH VALUES('FOOD9','AMERCIAN');
INSERT INTO PB06210445.DISH VALUES('FOOD10','HONGKONG');
INSERT INTO PB06210445.DISH VALUES('FOOD11','INDIAN');
INSERT INTO PB06210445.DISH VALUES('FOOD12','CANADA');
SELECT * FROM DISH;

INSERT INTO PB06210445.CALORIES VALUES('BEEF',1,20);
INSERT INTO PB06210445.CALORIES VALUES('CUMIN',2,4);
INSERT INTO PB06210445.CALORIES VALUES('EGG',1,10);
INSERT INTO PB06210445.CALORIES VALUES('BUTTER',1,5);
INSERT INTO PB06210445.CALORIES VALUES('FLOUR',3,9);
INSERT INTO PB06210445.CALORIES VALUES('PORK',2,36);
INSERT INTO PB06210445.CALORIES VALUES('TOMATO',1,8);
INSERT INTO PB06210445.CALORIES VALUES('POTATO',2,6);
SELECT * FROM CALORIES;

INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD1','BEEF',20);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD1','CUMIN',8);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD2','EGG',10);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD2','BUTTER',18);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD3','FLOUR',6);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD3','PORK',15);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD4','BUTTER',7);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD4','FLOUR',15);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD5','PORK',8);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD5','BUTTER',20);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD6','PORK',7);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD6','CUMIN',16);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD7','PORK',18);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD7','TOMATO',5);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD8','BEEF',12);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD8','FLOUR',20);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD9','CUMIN',19);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD9','POTATO',4);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD10','BEEF',18);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD10','BUTTER',10);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD11','TOMATO',6);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD11','CUMIN',12);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD12','BUTTER',9);
INSERT INTO PB06210445.INGREDIENTS VALUES('FOOD12','POTATO',18);
SELECT * FROM INGREDIENTS;

COMMIT;