ㅇㅇ
Tables (7)
Graduate
- ssn (Key2) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(45)
- age (Field2) — INT
- deg_prog (Field3) — VARCHAR(45)
- major (Key) — INT — Foreign key → department.dno — NOT NULL
- adviser (Key22) — INT — Foreign key → Graduate.ssn — NOT NULL
Professor
- ssn (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(45)
- age (Field2) — INT
- rank (Field3) — VARCHAR(45)
- speciality (Field4) — VARCHAR(45)
- Field5
Project
- pid — INT — Primary key — NOT NULL
- sponser (Field) — VARCHAR(45)
- start_date (Field2) — INT
- end_date (Field3) — INT
- budget (Field4) — INT
- ssn (Key2) — INT — Foreign key → Professor.ssn — NOT NULL
department
- dno (Key) — INT — Primary key — NOT NULL
- dname (Field) — VARCHAR(45)
- run (Key2) — INT — Foreign key → Professor.ssn — NOT NULL
- office (Field2) — VARCHAR(45)
- Field3
work dept (work_dept)
- ssn (Key) — INT — Foreign key → Professor.ssn — NOT NULL
- dno (Key2) — INT — Foreign key → department.dno — NOT NULL
- pct_time (Field) — INT
work in (work_in)
- ssn (Key) — INT — Foreign key → Professor.ssn — NOT NULL
- pid (Key2) — INT — Foreign key → Project.pid — NOT NULL
work_frog (Untitled4)
- pid (Key) — INT — Foreign key → Project.pid — NOT NULL
- ssn (Key2) — INT — Foreign key → Graduate.ssn — NOT NULL