Exercise1

Tables (6)

DEPARTMENT (COMPANY)

  • modelNO (model number) — char(5) — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • Field (number) — char(5)

PRODUCER

  • modelNO (proID) — char(5) — Primary key — NOT NULL
  • name (proName) — char(20)
  • address — char(40)
  • call (phone) — char(11)

PRODUCT

  • number (proID) — char(5) — Primary key — NOT NULL
  • explain — text
  • price — char(10)
  • Field (proName) — char(30)
  • Field

Untitled (PROPART)

  • Key — Primary key — NOT NULL
  • Key (partID) — char(5) — Foreign key → WORSON.Key — NOT NULL
  • number (proID) — char(5) — Foreign key → PRODUCT.number — NOT NULL
  • Field2 (qty) — char(5)

Untitled (CATEGORY)

  • Key (catID) — Primary key — NOT NULL
  • Field
  • Field2

WORSON (PART)

  • Key (partID) — char(5) — Primary key — NOT NULL
  • Field (direction) — text
  • modelNO (model number) — char(5) — Foreign key → PRODUCER.modelNO — NOT NULL