Madang_univ
Tables (7)
Department (Untitled2)
- dno (Field) — int — Primary key — NOT NULL
- dname (Field2) — varchar(40) — NOT NULL
- office (Field3) — varchar(20)
- dept_head (Field4) — int — Foreign key → Professor.ssn — NOT NULL
Graduate (Untitled3)
- ssn (Field) — varchar(40) — Primary key — NOT NULL
- name (Field2) — varchar(40) — NOT NULL
- age (Field3) — tinyint
- deg_prog (Field4) — char(2) — NOT NULL
- major (Field5) — int — Foreign key → Department.dno — NOT NULL
- advisor (Field7) — varchar(40) — Foreign key → Graduate.ssn
Professor (Untitled)
- ssn (Field) — varchar(40) — Primary key — NOT NULL
- name (Field2) — varchar(40) — NOT NULL
- age (Field3) — tinyint
- rank (Field4) — varchar(20)
- specialty (Field5) — varchar(20)
Project (Untitled4)
- pid (Field) — int — Primary key — NOT NULL
- sponsor (Field2) — varchar(40)
- start_date (Field3) — date
- end_date (Field4) — date
- budget (Field5) — int — NOT NULL
- manager (Field6) — varchar(40) — Foreign key → Professor.ssn — NOT NULL
work-in (Untitled5)
- p_ssn (Field3) — varchar(40) — Foreign key → Professor.ssn — NOT NULL
- pid (Field) — int — Foreign key → Project.pid — NOT NULL
work_dept (Untitled6)
- p_ssn (Field3) — varchar(40) — Foreign key → Professor.ssn — NOT NULL
- dno (Field) — int — Foreign key → Department.dno — NOT NULL
- pct_time (Field2) — int
work_prog (Untitled7)
- g_ssn (Field) — varchar(40) — Foreign key → Graduate.ssn — NOT NULL
- pid (Field2) — int — Foreign key → Project.pid — NOT NULL