dsu_university
Tables (4)
department (dept)
- department_number (dno) — integer — Primary key — NOT NULL
- department_name (dname) — varchar(40)
- department_office (office) — varchar(40)
graduatestu (graduate)
- graduateid (ssn) — integer — Primary key — NOT NULL
- graduate_name (name) — varchar(40)
- graduate_age (age) — integer
- degree_course (deg_prog) — varchar(30)
professor
- profid (ssn) — integer — Primary key — NOT NULL
- name — varchar(40)
- age — integer
- position (rank) — varchar(50)
- research (speciality) — varchar(40)
project
- projectid (pid) — integer — Primary key — NOT NULL
- support_org (sponsor) — varchar(40)
- start_date — date
- end_date — date
- budget — varchar(20)