학사 관리

테이블 (5)

Student

  • Key (sid) — 기본 키 — NOT NULL
  • Field (sname)
  • Field2 (ssn)
  • Field3 (address)
  • Field4 (tel)
  • Field (email)
  • Field (photo)
  • Field2 (deptno)

Untitled (Professor)

  • Key (pid) — 기본 키 — NOT NULL
  • Field (pname)
  • Field2 (ssn)
  • Field3 (address)
  • Field4 (tel)
  • Field5 (email)
  • Field6 (photo)
  • Field (deptno)

Untitled (Department)

  • Key (did) — 기본 키 — NOT NULL
  • Field (dname)
  • Field (dphone)

Untitled (Course)

  • Key (cid) — 기본 키 — NOT NULL
  • Field (cname)
  • Field (credit)
  • Field (time)
  • Field (room)

Untitled (Enrollment)

  • Key (eid) — 기본 키 — NOT NULL
  • Field (score)
  • Field (middle test)
  • Field (final test)
  • Field (other)
  • Field (total)
  • Field (grade)