DSU bookstore
Tables (4)
department
- department number (dno) — integer(10) — Primary key — NOT NULL
- department name (dname) — varchar(20) — NOT NULL
- department office (office) — integer(10) — NOT NULL
- ID (ssn) — integer(10) — Foreign key → professor.ID
gratudate students (graduate)
- ID (ssn) — integer(10) — Primary key — NOT NULL
- name — varchar(15) — NOT NULL
- age — integer(2) — NOT NULL
- degree course (deg_prog) — varchar(10) — NOT NULL
professor
- ID (ssn) — integer(10) — Primary key
- age — integer(10) — NOT NULL
- rank — varchar(15) — NOT NULL
- specialty — varchar(20) — NOT NULL
- name — varchar(15) — NOT NULL
project
- project number (pid) — integer(10) — Primary key — NOT NULL
- support org (sponsor) — varchar(20) — NOT NULL
- start date (start_date) — varchar(15) — NOT NULL
- end date (end_date) — varchar(15)
- budget — integer(10) — NOT NULL