University
Tables (7)
Department
- Dno — INT — Primary key — NOT NULL
- dname — Vachar(40)
- office — Vachar(40)
- SSN — INT — Foreign key → Professor.SSN — NOT NULL
Graduate
- SSN — INT — Primary key — NOT NULL
- G_Name — Vachar(40)
- G_Age — INT
- Deg_pro — INT
- Dno — INT — Foreign key → Department.Dno — NOT NULL
- SSN (SSN2) — INT — Foreign key → Graduate.SSN — NOT NULL
Professor
- SSN — INT — Primary key — NOT NULL
- P_Name — Vachar(40)
- P_Age — INT
- Speciality — Vachar(40)
- Field (Rank) — Vachar(40)
Project
- Pid — INT — Primary key — NOT NULL
- Sponsor — Vachar(40)
- start_date — DATE
- end_date — DATE
- budget — INT
- SSN — INT — Foreign key → Professor.SSN — NOT NULL
Work Prog (Work prog)
- Pid — INT — Foreign key → Project.Pid — NOT NULL
- SSN — INT — Foreign key → Graduate.SSN — NOT NULL
Work dept
- SSN — INT — Foreign key → Professor.SSN — NOT NULL
- Dno — INT — Foreign key → Department.Dno — NOT NULL
- Pct_time — INT
Work in
- SSN — INT — Foreign key → Professor.SSN — NOT NULL
- Pid — INT — Foreign key → Project.Pid — NOT NULL