ERD Exercise7
Tables (5)
ABC Corporation (Untitled4)
- Nmae (Key) — char(10) — Primary key — NOT NULL
- Adress (Field) — char(10)
- ProjetId (Field2) — char(5)
LoanInformation (Untitled5)
- LoanId (Key) — char(5) — NOT NULL
- ProjectId (Key3) — char(5) — Foreign key → Project.ProjectId — NOT NULL
- Amount (Key2) — char(10) — NOT NULL
- PaymentAmount (Field) — char(10)
- SpecializeId (Field2) — char(5) — Foreign key → Project.SpecializeId
PM (Untitled2)
- PMId (Key) — char(5) — Primary key — NOT NULL
- EmployeeID (Key3) — char(5) — Primary key — NOT NULL
- PMName (Field) — char(30)
- ProjectId (Key2) — char(5) — Foreign key → Project.ProjectId — NOT NULL
- SpecializeId (Field2) — char(5) — Foreign key → Project.SpecializeId
Project (Untitled)
- ProjectId (Key) — char(5) — Primary key — NOT NULL
- PMId (Field) — char(5)
- Id (Key2) — char(5) — Foreign key → Subcontractors.Id — NOT NULL
- PMId (Key4) — char(5) — Foreign key → PM.PMId — NOT NULL
- Nmae (Key3) — char(10) — Foreign key → ABC Corporation.Nmae — NOT NULL
- SpecializeId (Field2) — char(5) — Foreign key → Subcontractors.SpecializeId
Subcontractors (Untitled3)
- Id (Key) — char(5) — Primary key — NOT NULL
- SpecializeId (Field) — char(5) — Primary key
- Work (Key3) — char(10) — Primary key — NOT NULL
- Name (Field2) — char(30)
- Adress (Field3) — char(100)
- PhoneNumber (Field4) — char(11)
- ProjectId (Key2) — char(5) — Foreign key → Project.ProjectId — NOT NULL