11913007_과제 3
테이블 (7)
Depasrtment
- dno — VARCHAR2 (50) — 기본 키 — NOT NULL
- dname — VARCHAR2 (50)
- office — VARCHAR2 (50)
- ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL
Graduate
- ssn — VARCHAR2 (50) — 기본 키 — NOT NULL
- age — INT
- deg_prog — VARCHAR2 (50)
- name — VARCHAR2 (50)
- dno — VARCHAR2 (50) — 외래 키 → Depasrtment.dno — NOT NULL
- graduatessn — VARCHAR2 (50) — 외래 키 → Graduate.ssn — NOT NULL
Professor
- ssn — VARCHAR2 (50) — 기본 키 — NOT NULL
- name — VARCHAR2 (50)
- age — INT
- rank — VARCHAR2 (50)
- speciality — VARCHAR2 (50)
Project
- pid — VARCHAR2 (50) — 기본 키 — NOT NULL
- sponsor — VARCHAR2 (50)
- start_date — DATE
- end_date — DATE
- budget — INT
- ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL
Work_Prog (Work_prog)
- ssn — VARCHAR2 (50) — 외래 키 → Graduate.ssn — NOT NULL
- pid — VARCHAR2 (50) — 외래 키 → Project.pid — NOT NULL
Work_dept
- ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL
- dno — VARCHAR2 (50) — 외래 키 → Depasrtment.dno — NOT NULL
- pct_time (Field) — VARCHAR2 (50)
Work_in
- ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL
- pid — VARCHAR2 (50) — 외래 키 → Project.pid — NOT NULL