학생 관리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))