Company
테이블 (7)
Department(학과) (Department)
- dno — INTEGER
- dname — VARCHAR(50) — NOT NULL
- office — VARCHAR(50)
- run_prof_ssn — INTEGER
Graduate(대학원생) (Graduate)
- ssn — INTEGER
- name — VARCHAR(50) — NOT NULL
- age — INTEGER
- deg_prog — VARCHAR(20)
- major_dno — INTEGER
- advisor_ssn — INTEGER
Professor(교수) (Professor)
- ssn — INTEGER
- name — VARCHAR(50) — NOT NULL
- age — INTEGER
- rank — VARCHAR(20)
- speciality — VARCHAR(50)
Project(과제) (Project)
- pid — INTEGER
- sponsor — VARCHAR(50)
- start_date — DATE
- end_date — DATE
- budget — INTEGER
- manage_prof_ssn — INTEGER — NOT NULL
Work_Dept
- prof_ssn — INTEGER
- dno — INTEGER
- pct_time — INTEGER
Work_In
- pid — INTEGER
- prof_ssn — INTEGER
Work_Prog
- pid — INTEGER
- grad_ssn — INTEGER