ER다이어그램
테이블 (6)
Dept (Untitled2)
- dno (Key) — 기본 키 — NOT NULL
- dname (Field)
- office (Field2)
- runprofessorssn (Key2) — 외래 키 → Professor.ssn — NOT NULL
Graduate (Untitled3)
- ssn (Key) — 기본 키 — NOT NULL
- name (Field)
- age (Field2)
- deg_prog (Field3)
- graduatessn (Key2) — 외래 키 → Graduate.ssn — NOT NULL
- dno (Key3) — 외래 키 → Dept.dno — NOT NULL
Professor (Untitled)
- ssn (Key) — 기본 키 — NOT NULL
- name (Field)
- age (Field2)
- rank (Field3)
- speciallity (Field4)
Project (Untitled4)
- pid (Key) — 기본 키 — NOT NULL
- sponsor (Field)
- start_date (Field2)
- end_date (Field3)
- budget (Field4)
Work-In (Untitled5)
- professorssn (Key) — 외래 키 → Professor.ssn — NOT NULL
- pid (Key2) — 외래 키 → Project.pid — NOT NULL
Work-Prog (Untitled6)
- pid (Key) — 외래 키 → Project.pid — NOT NULL
- graduatessn (Key2) — 외래 키 → Graduate.ssn — NOT NULL