HW1(10_06)

Tables (4)

Part (Untitled2)

  • SerialNo (Key) — integer — Primary key — NOT NULL
  • Summary (Field) — char(50)
  • serialNo (Key2) — integer — Foreign key → Producer.serialNo — NOT NULL
  • SerialNo (Key3) — integer — Foreign key → Product.SerialNo — NOT NULL

Part Volume (Untitled4)

  • PARTvoID (Key) — integer — Primary key — NOT NULL
  • SerialNo (Key4) — integer — Foreign key → Part.SerialNo — NOT NULL
  • SerialNo (Key3) — integer — Foreign key → Product.SerialNo — NOT NULL
  • gty (Key5) — integer — NOT NULL

Producer (Untitled)

  • serialNo (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(50)
  • phone (Field3) — integer

Product (Untitled3)

  • SerialNo (Key) — integer — Primary key — NOT NULL
  • Summary (Field) — char(50)
  • Price (Field2) — integer