Lab Practice

Tables (7)

Department

  • department number (dno) — NUMBER — Primary key — NOT NULL
  • Chief Professor ID (ssn) — NUMBER — Foreign key → Work department.Professor ID — NOT NULL
  • department name (dname) — VARCHAR(30)
  • office — VARCHAR(30)

Graduate

  • Graduate ID (ssn) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR(30)
  • age — NUMBER
  • degree progress (deg_prog) — VARCHAR(10)
  • Advisor (graduatessn) — NUMBER — Foreign key → Graduate.Graduate ID — NOT NULL
  • major (dno) — NUMBER — Foreign key → Department.department number — NOT NULL

Professor

  • Professor ID (ssn) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR(30)
  • rank — VARCHAR(40) — NOT NULL
  • speciality — String
  • age — NUMBER
  • department number (dno) — NUMBER — Foreign key → Department.department number — NOT NULL

Project

  • project id (pid) — NUMBER — Primary key — NOT NULL
  • sponsor — VARCHAR(30)
  • start date (start_date) — Date
  • end date (end_date) — Date
  • budget — NUMBER
  • Professor ID (ssn) — NUMBER — Foreign key → Professor.Professor ID — NOT NULL

Work department (Work-dep)

  • Professor ID (ssn) — NUMBER — Foreign key → Professor.Professor ID — NOT NULL
  • percentage time (pct-time) — NUMBER

Work in

  • Professor ID (ssn) — NUMBER — Foreign key → Professor.Professor ID — NOT NULL
  • project id (pid) — NUMBER — Foreign key → Project.project id — NOT NULL

Work progress

  • project id (pid) — NUMBER — Foreign key → Project.project id — NOT NULL
  • Graduate ID (ssn) — NUMBER — Foreign key → Graduate.Graduate ID — NOT NULL