Excercise1_0923

Tables (5)

COMPANY

  • FK (Pro ID) — INT(20) — Primary key — NOT NULL
  • FK (Producer ID) — INT(20) — Primary key — NOT NULL
  • Field (Company Name) — CHAR(40)
  • Field2 (Location) — CHAR(100)

PART

  • PK (Part ID) — INT(20) — Primary key — NOT NULL
  • FK (Pro ID) — INT(20) — Foreign key → PART_NUM_PER_PRODUCT.FK — NOT NULL
  • Field (Description) — CHAR(100)

PART_NUM_PER_PRODUCT (Part_Num_Per_Product)

  • FK (Pro ID) — INT(20) — Primary key — NOT NULL
  • FK (Part ID) — INT(20) — Primary key — NOT NULL
  • Field (Part Count) — INT(100)

PRODUCER

  • PK (Producer ID) — INT(20) — Primary key — NOT NULL
  • FK (Pro ID) — INT(20) — Foreign key → COMPANY.FK — NOT NULL
  • FK (Producer ID2) — INT(20) — Foreign key → COMPANY.FK — NOT NULL
  • Field (Name) — CHAR(100)
  • Field (Address) — CHAR(200)
  • Field (Phone) — INT(20)

PRODUCT

  • PK (Pro ID) — INT(20) — Primary key — NOT NULL
  • FK (Part ID) — INT(20) — Foreign key → PART_NUM_PER_PRODUCT.FK — NOT NULL
  • FK (Producer ID) — INT(20) — Foreign key → COMPANY.FK — NOT NULL
  • Field (Description) — CHAR(100)
  • Field (Price) — INT(20)