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