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