ERD Exercise 1

Tables (4)

PART (Untitled2)

  • partNo (Key) — char(10) — Primary key — NOT NULL
  • description (Field) — char(50)
  • price (Field2) — char(10)
  • supplierNo (Key2) — char(10) — Foreign key → SUPPLIER.supplierNo — NOT NULL

PART-_QUANTITY (Untitled4)

  • partNo (Key2) — char(10) — Foreign key → PART.partNo — NOT NULL
  • acount (Field2) — char(5)

PRODUCT (Untitled)

  • productNo (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(20)
  • description (Field2) — char(50)
  • price (Field3) — char(10)
  • partNo (Key22) — char(10) — Foreign key → PART-_QUANTITY.partNo — NOT NULL

SUPPLIER (Untitled3)

  • supplierNo (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(20)
  • phoneNo (Field3) — char(11)
  • partNo (Key2) — char(10) — Foreign key → PART.partNo — NOT NULL