ex1

Tables (5)

Part (Untitled3)

  • part_id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)

Part_Supplier (Untitled5)

  • part_id (Key) — Primary key — NOT NULL
  • Field

Product (Untitled)

  • Key — Primary key — NOT NULL
  • part_id (Key2) — Foreign key → Part.part_id — NOT NULL
  • product_id (Field)
  • name (Field2)
  • description (Field3)
  • price (Field4)
  • Key (Key3) — Foreign key → Product.Key — NOT NULL
  • part_id (Key22) — Foreign key → Product.part_id — NOT NULL

Product_Part (Untitled4)

  • product_id (Key) — Primary key — NOT NULL
  • part_id (Key2) — Foreign key → Part.part_id — NOT NULL
  • part_id (Field)
  • quantity (Field2)

Supplier (Untitled2)

  • supplier_id (Key) — Primary key — NOT NULL
  • part_id (Key2) — Foreign key → Part.part_id — NOT NULL
  • part_id (Key3) — Foreign key → Part_Supplier.part_id — NOT NULL
  • Key (Key4) — Foreign key → Product.Key — NOT NULL
  • part_id (Key22) — Foreign key → Product.part_id — NOT NULL
  • name (Field)
  • address (Field2)
  • phone (Field3)