ERD Exercise 7
Tables (4)
Untitled (project)
- Key (projectNo) — Char — Primary key — NOT NULL
- Key (PM(ssn)) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (subcontractorsNo) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (loanNo) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (PM)
- Key (ssn) — Char — Primary key — NOT NULL
- Field (name) — Char
Untitled (subcontractors)
- Key (subcontractorsNo) — Char — Primary key — NOT NULL
- Field (code) — Char
Untitled (loan)
- Key (loanNo) — Char — Primary key — NOT NULL
- Field (amount) — int
- Field (payment) — int