Exercise 7
Tables (5)
Untitled (PROJECT)
- Key (assignID) — char(10) — Primary key — NOT NULL
- Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field
- Key (loanNumber) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (LOANS)
- Key (loanNumber) — char(5) — Primary key — NOT NULL
- Field (amount) — integer
- Field (payment) — integer
Untitled (PM)
- Key (employeeID) — char(10) — Primary key — NOT NULL
- Key (assignID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — char(10)
- Field (information) — text
Untitled (SUBCONTRACTOR)
- Key (subID) — char(5) — Primary key — NOT NULL
- Field (description) — text
Untitled (CORPORATION)
- Key (assignID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (subID) — char(5) — Foreign key → Untitled.Key — NOT NULL