ERD EXCERCISE 7
Tables (7)
Untitled (CORPORATION)
- Key (corporID) — integer — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(10)
- Field (email) — char(50)
Untitled (PROJECT)
- Key (projectID) — integer — Primary key — NOT NULL
- Field (name) — char(30)
- Field
- Key (managerNO) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (corporID) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (SPECIFIC LOAN)
- Key (specificID) — integer — Primary key — NOT NULL
- Field (amount) — char(30)
- Field (payment) — char(30)
Untitled (PROJECT-MANAGER)
- Key (managerNO) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — char(10)
Untitled (SUB CONTRACTOR)
- Key (subcontractorID) — integer — Primary key — NOT NULL
- Field (name) — char(20)
- Key (projectID) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (address) — char(30)
- Field (phone) — char(10)
Untitled (SPECIALIZATION)
- Key (specializationID) — integer — Primary key — NOT NULL
- Field (plumbing) — text
- Field (heating) — text
- Key (subcontractorID) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (PROJECT-SPECIFIC LOAN)
- Key (specificID) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (projectID) — integer — Foreign key → Untitled.Key — NOT NULL