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