DSU University
Tables (4)
Graduate students (graduate)
- ID (ssn) — Primary key — NOT NULL
- name
- age
- degree course (deg_prog) — master / doctor
Professor (professor)
- ID (ssn) — Primary key — NOT NULL
- name
- age
- position (rank)
- research field (specialitty)
department (dept)
- department number (dno) — Primary key — NOT NULL
- ID (ssn) — Foreign key → Professor.ID — NOT NULL
- department name (dname)
- department office (office)
project
- project number (pid) — Primary key — NOT NULL
- support organization (sponsor)
- start date (start_date)
- end date (end_date)