test

테이블 (5)

Course (course)

  • PID (pid) — int — 외래 키 → Professor.PID — NOT NULL
  • CID (cid) — char(10) — 외래 키 → 교과목.CID — NOT NULL
  • SID (sid) — char(10) — 외래 키 → Student.SID — NOT NULL
  • 성적 — char(2)
  • Field (개설년도) — int
  • Field (개설학기) — int

Department (department)

  • DeptID (deptid) — char(8) — 기본 키 — NOT NULL
  • DeptName (deptname) — vchar(30)
  • Phone (phone) — char(13)

Professor (professor)

  • PID (pid) — int — 기본 키 — NOT NULL
  • DeptID (deptid) — char(8) — 외래 키 → Department.DeptID — NOT NULL
  • Name (name) — varchar(10)
  • Phone (phone) — varchar*15)

Student (student)

  • SID (sid) — char(10) — 기본 키 — NOT NULL
  • DeptID (deptid) — char(8) — 외래 키 → Department.DeptID — NOT NULL
  • Name (name) — varchar(30)
  • Phone (phone) — varchar(30)

교과목

  • CID (cid) — char(10) — 기본 키 — NOT NULL
  • Name (name) — varchar(20)
  • 학점 — int