6
Tables (7)
Dept
- dno — Primary key — NOT NULL
- dname
- office
- ssn — Foreign key → Professor.ssn — NOT NULL
Graduate
- ssn — Primary key — NOT NULL
- name
- age
- deg_prog
- dno — Foreign key → Dept.dno — NOT NULL
- ssn (ssn2) — Foreign key → Graduate.ssn — NOT NULL
Professor
- ssn — Primary key — NOT NULL
- name
- age
- rank
- speciality
Project
- pid — Primary key — NOT NULL
- sponsor
- start_date
- end_date
- budget
- ssn — Foreign key → Professor.ssn — NOT NULL
Work_Dept
- ssn — Foreign key → Professor.ssn — NOT NULL
- dno — Foreign key → Dept.dno — NOT NULL
- pct_time
Work_In
- ssn — Foreign key → Professor.ssn — NOT NULL
- pid — Foreign key → Project.pid — NOT NULL
Work_Prog
- ssn — Foreign key → Graduate.ssn — NOT NULL
- pid — Foreign key → Project.pid — NOT NULL