학생 관리3
테이블 (3)
SCORE
- SC_NUM — INT
- SC_ST_KEY — INT — NOT NULL
- SC_SJ_NUM — INT — NOT NULL
- SC_SCORE — INT — NOT NULL
- CHECK(SC_SCORE — BETWEEN
STUDENT
- ST_KEY — INT
- ST_GRADE — INT — NOT NULL
- ST_CLASS — INT — NOT NULL
- ST_NUM — INT — NOT NULL
- ST_NAME — VARCHAR(20) — NOT NULL
- CHECK(ST_GRADE — >=
- CHECK(ST_CLASS — >=
- CHECK(ST_NUM — >=
SUBJECT
- SJ_NUM — INT
- SJ_GRADE — INT — NOT NULL
- SJ_SEMESTER — ENUM("1","2") — NOT NULL
- SJ_NAME — VARCHAR(10) — NOT NULL
- CHECK(SJ_GRADE — IN(1,2,3))