test2

Tables (4)

Untitled (학생)

  • Key (학생ID) — Primary key — NOT NULL
  • Field (학생이름) — VARCHAR(50)
  • Field (학과) — VARCHAR(50)

Untitled (과목)

  • Key (과목코드) — Primary key — NOT NULL
  • Field (과목명) — VARCHAR(100)
  • Field (학점) — INT
  • Key (교수ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (교수)

  • Key (교수ID) — Primary key — NOT NULL
  • Field (교수이름) — VARCHAR(50)

Untitled (수강)

  • Key (학생ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (과목코드) — Foreign key → Untitled.Key — NOT NULL