MADANG
Tables (11)
Untitled (Professor)
- Key (ssn) — VARCHAR(20) — Primary key — NOT NULL
- Field (name) — VARCHAR(20) — NOT NULL
- Field2 (age) — INTEGER — NOT NULL
- Field3 (rank) — VARCAHR(20) — NOT NULL
- Field4 (speciality) — VARCHAR(50) — NOT NULL
Untitled (Department)
- Key (dno) — INTEGER — Primary key — NOT NULL
- Field (dname) — VARCHART(20) — NOT NULL
- Field2 (office) — VARCHART(20) — NOT NULL
Untitled (Graduate)
- Key (ssn) — Primary key — NOT NULL
- Key (dno) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field2 (age)
- Field3 (deg_prog)
Untitled (Project)
- Key (pid) — Primary key — NOT NULL
- Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn2) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Field (sponsor)
- Field2 (start_date)
- Field3 (end_date)
- Field4 (budget)
Untitled (major)
- Key (dno) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (run)
- Field — NOT NULL
- Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (manage)
- Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (work-dept)
- Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Field (pct_time)
Untitled (advisor)
- Key (ssn) — Foreign key → Untitled.Key — NOT NULL
- Key (dno) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (work-in)
- Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (work-prog)
- Key (ssn) — Foreign key → Untitled.Key — NOT NULL
- Key (dno) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Key (pid) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn2) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn22) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL