학사관리시스템

테이블 (6)

BELONG

  • Dnum (number) — number — 외래 키 → DEPARTMENT.Dnum — NOT NULL
  • Pnum (number2) — number — 외래 키 → PROFESSOR.Pnum — NOT NULL

CLASS

  • Snum (number) — number — 외래 키 → STUDENT.Snum — NOT NULL
  • Lnumber (number2) — number — 외래 키 → LECTURE.Lnumber — NOT NULL
  • score — number

DEPARTMENT

  • Dnum (number) — number — 기본 키 — NOT NULL
  • Dname (name) — varchar
  • Dphone (phone) — varchar

LECTURE

  • Lnumber (number) — number — 기본 키 — NOT NULL
  • Lname (name) — varchar
  • Pnum (number2) — number — 외래 키 → PROFESSOR.Pnum — NOT NULL
  • Lscore (score) — number
  • year — number
  • semester — number
  • Dnum (number3) — number — 외래 키 → DEPARTMENT.Dnum — NOT NULL
  • Ltime (time) — varchar

PROFESSOR

  • Pnum (number) — number — 기본 키 — NOT NULL
  • Pphone (phone) — varchar
  • Pmajor (major) — varchar
  • Pname (name) — varchar
  • Pemail (email) — varchar

STUDENT

  • Snum (number) — number — 기본 키 — NOT NULL
  • Sphone (phone) — varchar
  • Smajor (major) — varchar
  • Sgrade (grade) — number
  • Sname (name) — varchar
  • Pnum (number3) — number — 외래 키 → PROFESSOR.Pnum — NOT NULL
  • Semail (email) — varchar
  • Dnum (number2) — number — 외래 키 → DEPARTMENT.Dnum — NOT NULL