madanguniversity
Tables (7)
Dept (Untitled4)
- dno (Key) — Primary key — NOT NULL
- dname (Field2)
- office (Field3)
- ssn (Key2) — Foreign key → Professor.ssn — NOT NULL
Graduate (Untitled5)
- ssn (Key) — Primary key — NOT NULL
- name (Field2)
- age (Field3)
- deg_prog (Field4)
- ssn (Key2) — Foreign key → Graduate.ssn — NOT NULL
- dno (Key3) — Foreign key → Dept.dno — NOT NULL
Professor (Untitled)
- ssn (Key) — Primary key — NOT NULL
- age (Field)
- rank (Field2)
- speciality (Field3)
- name (Field4)
Project (Untitled3)
- pid (Key) — Primary key — NOT NULL
- sponsor (Field2)
- start_date (Field3)
- end_date (Field4)
- budget (Field5)
- ssn (Key2) — Foreign key → Professor.ssn — NOT NULL
work dept (Untitled6)
- ssn (Key) — Foreign key → Professor.ssn — NOT NULL
- dno (Key2) — Foreign key → Dept.dno — NOT NULL
- pct time (Field)
work in (Untitled2)
- ssn (Key) — Foreign key → Professor.ssn — NOT NULL
- pid (Key2) — Foreign key → Project.pid — NOT NULL
work prog (Untitled7)
- pid (Key) — Foreign key → Project.pid — NOT NULL
- ssn (Key2) — Foreign key → Graduate.ssn — NOT NULL