ERD Exercise 1

Tables (4)

Untitled (product)

  • Key (productNo) — Char(20) — Primary key — NOT NULL
  • Field (description) — text
  • Field (price) — Char(20)

Untitled (part)

  • Key (partNo) — Char(20) — Primary key — NOT NULL
  • Field (description) — text
  • Key (producerNo) — Char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (producer)

  • Key (producerNo) — Char(14) — Primary key — NOT NULL
  • Field (name) — Char(20)
  • Field (address) — Char(30)
  • Field (phone) — Char(10)

Untitled (product-part)

  • Key (productNo) — Char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (partNo) — Char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (partQuantity) — int