ERD Exercise 1

Tables (4)

BILL_OF_MATERIALS (Untitled3)

  • product_id (INT) — product_id
  • part_id (int) — part_id
  • quantity (InT) — amount

MANUFACTURER (Untitled4)

  • manufacturer_id (INT) — original id
  • name (VARCHAR) — Product name
  • address (TEXT) — address
  • phone (Varchar) — phone

PART (Untitled2)

  • part_id (INT) — original id
  • description (TEXT) — explain
  • manufacturer_id (int) — manufacturer_id

PRODUCT (Untitled)

  • product_id (INT) — original id
  • name (VARCHAR) — product name
  • description (TEXT) — explain
  • price (DECIMAL) — price