학사관리 과제
테이블 (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