DSUuniversity
Tables (5)
customer
- custid — integer — Primary key — NOT NULL
- Field
- Field2
department
- department_no — integer — Primary key — NOT NULL
- department_name — varchar(20)
- department_office — varchar(40)
- professor_id — integer — Foreign key → professor.professor_id — NOT NULL
- department_no (department_no2) — integer — Foreign key → professor.department_no — NOT NULL
graduate_students
- grad_id — integer — Primary key — NOT NULL
- grad_name — varchar(40)
- grad_age — integer
- grad_degree_course — varchar(20)
professor
- professor_id — integer — Primary key — NOT NULL
- department_no — integer — Foreign key → department.department_no — NOT NULL
- professor_name — varchar(40)
- professor_age — integer
- position — varchar(20)
- research_field — varchar(60)
project
- project_id — integer — Primary key — NOT NULL
- sponsor (sponser) — varchar(20)
- start_date — varchar(40)
- end_date — varchar(40)
- budget — varchar(20)