13
Tables (7)
Dept (Untitled6)
- dno (Key) — Primary key — NOT NULL
- dname (Field)
- office (Field2)
- snn (Key2) — Foreign key → Professor.snn — NOT NULL
Graduate (Untitled5)
- snn (Key) — Primary key — NOT NULL
- name (Field)
- age (Field2)
- deg_prog (Field3)
- graduatesnn (Key2) — Foreign key → Graduate.snn — NOT NULL
- dno (Key3) — Foreign key → Dept.dno — NOT NULL
Professor (Untitled)
- snn (Key) — Primary key — NOT NULL
- name (Field)
- age (Field2)
- rank (Field3)
- speciality (Field4)
Project (Untitled3)
- pid (Key) — Primary key — NOT NULL
- sponsor (Field)
- start_date (Field2)
- end-date (Field3)
- budget (Field4)
- snn (Key2) — Foreign key → Professor.snn — NOT NULL
Work_Dept (Untitled7)
- snn (Key) — Foreign key → Professor.snn — NOT NULL
- dno (Key2) — Foreign key → Dept.dno — NOT NULL
- pct_time (Field)
Work_In (Untitled2)
- pid (Key) — Foreign key → Project.pid — NOT NULL
- snn (Key2) — Foreign key → Professor.snn — NOT NULL
Work_prog (Untitled4)
- pid (Key) — Foreign key → Project.pid — NOT NULL
- snn (Key2) — Foreign key → Graduate.snn — NOT NULL