ERD Exercise1

Tables (5)

CATEGORY (Untitled4)

  • cateNum (Key) — char(30) — Primary key — NOT NULL
  • name (Field) — char(100)
  • description (Field2) — text

PART (Untitled3)

  • partID (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(20)
  • modelNumber (Field2) — char(30)
  • description (Field3) — text
  • price (Field4) — integer
  • suplierID (Key2) — integer(10) — Foreign key → SUPPLIER.suplierID — NOT NULL
  • cateNum (Key3) — char(30) — Foreign key → CATEGORY.cateNum — NOT NULL

PRODUCT (Untitled2)

  • modelNumber (Key) — char(30) — Primary key — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — text
  • price (Field3) — integer

PRODUCT_PART (Untitled5)

  • modelNumber (Key) — char(30) — Foreign key → PRODUCT.modelNumber — NOT NULL
  • partID (Key2) — integer — Foreign key → PART.partID — NOT NULL
  • quantity (Field) — integer(10)

SUPPLIER (Untitled)

  • suplierID (Key) — integer(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — char(30)
  • email (Field3) — email
  • address (Field4) — char(50)
  • description (Field5) — text
  • grade (Field6) — integer(1)