ERD Exercise 1

Tables (5)

Untitled (SUPPLIER)

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

Untitled2 (PART)

  • Key (partID) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field2 (modelNumber) — char(30)
  • Field3 (description) — text
  • Field4 (price) — integer
  • Field5 — interger(10)
  • Field6 (cateNum) — char(30)

Untitled3 (PRODUCT)

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

Untitled4 (PRODUCT_PART)

  • Key (modelNumber) — char(30) — Primary key — NOT NULL
  • Key2 (partID) — integer — Primary key — NOT NULL
  • Field (quantity) — integer(10)

Untitled5 (CATEGORY)

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