excercise 7

Tables (5)

familiar subcontractors (Untitled5)

  • no (Key) — char(10) — Primary key — NOT NULL
  • Field

loans (Untitled4)

  • loans no (Key) — char(20) — Primary key — NOT NULL
  • quantity (Field) — char(10)
  • payment (Field2) — char(10)
  • prono (Key2) — char(10) — Foreign key → project.prono — NOT NULL

project (Untitled)

  • prono (Key) — char(10) — Primary key — NOT NULL
  • managerno (Key2) — char(10) — Foreign key → project manager.managerno — NOT NULL
  • no (Key3) — char(10) — Foreign key → familiar subcontractors.no — NOT NULL

project manager (Untitled2)

  • managerno (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)

subcontractor (Untitled3)

  • one's field (Key) — char(20) — Primary key — NOT NULL
  • prono (Key2) — char(10) — Foreign key → project.prono — NOT NULL