Database
Tables (4)
Professor
- profid (ssn) — integer — Primary key — NOT NULL
- profname — varchar(30)
- age — integer
- position (rank) — integer
- research_field (speciality) — varchar(40)
department (dept)
- department_number (dno) — integer — Primary key — NOT NULL
- department_name (dname) — varchar(40)
- departmant_office (office) — varchar(35)
graduate_students (greaduate)
- ID (ssn) — integer — Primary key — NOT NULL
- name — varchar(29)
- age — integer
- degree_course (deg_prog) — varchar(25)
project
- project_number (pid) — integer — Primary key — NOT NULL
- support_organisation (sponsor) — varchar(45)
- start_date — date
- budget — integer