ERD Exercise 1

Tables (4)

Component (Untitled2)

  • Key (component number) — char(20) — Primary key — NOT NULL
  • Field (explain) — char(30)

Producer (Untitled3)

  • Key (producer number) — char(20) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(30)
  • Field (phone number) — integer(11)

Product (Untitled)

  • Key (product number) — char(20) — Primary key — NOT NULL
  • Field (explain) — char(30)
  • Field (price) — integer(10)

Workson (Untitled4)

  • Key (component number) — char(20) — Foreign key → Component.Key — NOT NULL
  • Key (product number) — char(20) — Foreign key → Product.Key — NOT NULL
  • Field (hours) — float