CREATE TABLE SCORE(
號碼 NUMBER(5) PRIMARY KEY,
語文　NUMBER(3) CHECK(語文 BETWEEN 0 AND 150),
數(shù)學(xué)  NUMBER(3) CHECK(數(shù)學(xué) BETWEEN 0 AND 150),
英語  NUMBER(3) CHECK(英語 BETWEEN 0 AND 150),
綜合  NUMBER(3) CHECK(綜合 BETWEEN 0 AND 150),
X科　NUMBER(3) CHECK(X科 BETWEEN 0 AND 150),
總分 NUMBER(3),
CONSTRAINT FK_4 FOREIGN KEY (號碼)
 REFERENCES STUDENT (編號));