DB_ERDexercise1_0929

Tables (4)

Untitled (MAKER)

  • Key (makeID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (add) — char(50)
  • Field (phone) — char(11)

Untitled (PROD_PART)

  • Key (ppNo) — char(20) — Primary key — NOT NULL
  • Key (partNo) — char(10) — Foreign key → Untitled3.Key — NOT NULL
  • Key (prodNo) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field (qty) — char(10)

Untitled2 (PRODUCK)

  • Key (prodNo) — char(10) — Primary key — NOT NULL
  • Field (expl) — char(100)
  • Field (price) — char(10)

Untitled3 (PART)

  • Key (partNo) — char(10) — Primary key — NOT NULL
  • Field (expl) — char(100)
  • Key (makeID) — char(10) — Foreign key → Untitled.Key — NOT NULL