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