ERD exercise 4(20200916)
Tables (6)
HIRED (Untitled4)
- businessNo (Key) — CHAR(20) — Primary key — NOT NULL
- projID (Key2) — CHAR(20) — Foreign key → PROJECT.projID — NOT NULL
- scID (Key3) — CHAR(20) — Foreign key → SUBCONTRACTOR.scID — NOT NULL
LOAN (Untitled6)
- loanID (Key) — CHAR(20) — Primary key — NOT NULL
- amount (Field) — int(20)
- paymentAmout (Field2) — int(20)
- projID (Key2) — CHAR(20) — Foreign key → PROJECT.projID — NOT NULL
- creditor (Field3) — CHAR(30)
PROJECT (Untitled)
- projID (Key) — CHAR(20) — Primary key — NOT NULL
- projName (Field) — CHAR(30)
- PMssn (Key2) — CHAR(20) — Foreign key → PROJECT_MANAGER.ssn — NOT NULL
- PMStartDate (Field2) — date
PROJECT_MANAGER (Untitled2)
- ssn (Key) — CHAR(20) — Primary key — NOT NULL
- PMName (Field) — CHAR(30)
- address (Field2) — CHAR(50)
- phone (Field3) — CHAR(20)
SPECIALTY (Untitled5)
- speID (Field2) — CHAR(20) — Primary key
- description (Field) — CHAR(100)
- speName (Field3) — CHAR(30)
SUBCONTRACTOR (Untitled3)
- scID (Key) — CHAR(20) — Primary key — NOT NULL
- scName (Field) — CHAR(30)
- address (Field2) — CHAR(50)
- phone (Field3) — CHAR(20)
- speID (Field22) — CHAR(20) — Foreign key → SPECIALTY.speID