학사관리 과제

테이블 (5)

Untitled (Student)

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

Untitled (Professor)

  • Key (pid) — 기본 키 — NOT NULL
  • Field2 (pname)
  • Field3 (idnum)
  • Field4 (address)
  • Field5 (tel)
  • Field6 (email)
  • Field7 (photo)
  • Field8 (dpetno)

Untitled (Course)

  • Key (cid) — 기본 키 — NOT NULL
  • Field (cname)
  • Field2 (credit)
  • Field3 (time)
  • Field4 (room)
  • Field5 (pid)
  • Field (did)

Untitled (Department)

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

Untitled (Enrollment)

  • Key — 기본 키 — NOT NULL