과제
테이블 (7)
Dept (dept)
- ssn — VARCHAR(20) — 기본 키 — NOT NULL
- dno — INT(11)
- dname — VARCHAR(20)
- office — VARCHAR(20)
Graduate (graduate)
- dno — INT(11) — 기본 키 — NOT NULL
- graduatessn — VARCHAR(20) — 기본 키 — NOT NULL
- ssn — VARCHAR(20)
- name — VARCHAR(20)
- age — INT(11)
- deg_prog — INT(11)
- dno (dno2) — INT(11) — 외래 키 → Graduate.dno — NOT NULL
- graduatessn (graduatessn2) — VARCHAR(20) — 외래 키 → Graduate.graduatessn — NOT NULL
Professor (professor)
- name — VARCHAR(20)
- age — INT(11)
- rank — VARCHAR(20)
- speciality — VARCHAR(20)
- ssn — VARCHAR(20)
Project (project)
- ssn — VARCHAR(20) — 기본 키 — NOT NULL
- pid — INT(11)
- sponsor — VARCHAR(20)
- start_date — INT(11)
- end_date — INT(11)
- budget — INT(50)
Work_Dept (work_dept)
- ssn — VARCHAR(20) — 외래 키 → Dept.ssn — NOT NULL
- pct_time — INT(11)
- dno — INT(11)
Work_In (work_in)
- ssn — VARCHAR(20) — 외래 키 → Project.ssn — NOT NULL
Work_Prog (work_prog)
- ssn — VARCHAR(20) — 기본 키 — NOT NULL
- pid — INT(11) — 기본 키 — NOT NULL
- ssn (ssn2) — VARCHAR(20) — 외래 키 → Project.ssn — NOT NULL
- dno (dn) — INT(11) — 외래 키 → Graduate.dno — NOT NULL
- graduatessn (gs) — VARCHAR(20) — 외래 키 → Graduate.graduatessn — NOT NULL