HW1(2017310367)

Tables (5)

CATEGORY (Untitled5)

  • catID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(20)
  • description (Field2) — text

PART (Untitled2)

  • partID (Key) — char(30) — Primary key — NOT NULL
  • partName (Field) — char(30)
  • description (Field2) — text
  • price (Field3) — int(10)
  • supID (Key2) — char(30) — Foreign key → SUPPLIER.supID — NOT NULL
  • catID (Key3) — char(10) — Foreign key → CATEGORY.catID — NOT NULL

PRODUCT_PART (Untitled3)

  • proID (Key) — char30 — Foreign key → PROJECT.proID — NOT NULL
  • partID (Key2) — char(30) — Foreign key → PART.partID — NOT NULL
  • quantity (Field) — int(10)

PROJECT (Untitled)

  • proID (Key) — char30 — Primary key — NOT NULL
  • proName (Field) — char(30)
  • category (Field2) — char(30)
  • description (Field3) — text
  • price (Field4) — int(10)
  • releasedDate (Field5) — date

SUPPLIER (Untitled4)

  • supID (Key) — char(30) — Primary key — NOT NULL
  • supName (Field) — char(30)
  • phone (Field2) — char(12)
  • email (Field3) — char(30)
  • fax (Field4) — char(30)
  • grade (Field5) — text
  • description (Field6) — text