Howon
Tables (7)
Deparment (Department)
- Dno — INT — Primary key — NOT NULL
- dname — VARCHAR(40)
- office — VARCHAR(40)
- SSN — INT
- SSN (SSN2) — INT — Foreign key → Professor.SSN
Graduate
- SSN — INT — Primary key — NOT NULL
- G_Name — VARCHAR(40)
- G_Age — INT
- Deg_pro — INT
- Dno — INT
- SSN (SSN2) — INT
- Dno (Dno2) — INT — Foreign key → Deparment.Dno — NOT NULL
- SSN (SSN3) — INT — Foreign key → Graduate.SSN — NOT NULL
Professor (prof)
- SSN — INT — Primary key
- P_Name (program_id) — VARCHAR(40)
- P_Age — INT
- Speciality — VARCHAR(40)
- Field (Rank) — VARCHAR(40)
Project
- PID (Pid) — INT — Primary key — NOT NULL
- SPONSOR (Sponsor) — VARCHAR(40)
- start_date — DATE
- end_date — DATE
- budget — INT
- SSN — INT
- SSN (SSN2) — INT — Foreign key → Professor.SSN
Work Prog (Work prog)
- Pid — INT — Primary key — NOT NULL
- SSN — INT
- PID (Pid2) — INT — Foreign key → Project.PID — NOT NULL
- SSN (SSN2) — INT — Foreign key → Graduate.SSN — NOT NULL
Work dept
- SSN — INT — Primary key — NOT NULL
- Dno — INT
- Pct_time — INT
- SSN (SSN2) — INT — Foreign key → Professor.SSN
- Dno (Dno2) — INT — Foreign key → Deparment.Dno — NOT NULL
Work in
- SSN — INT — Primary key — NOT NULL
- PID (Pid) — INT
- SSN (SSN2) — INT — Foreign key → Professor.SSN
- PID (Pid2) — INT — Foreign key → Project.PID — NOT NULL