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