exec1

Tables (5)

component (Untitled3)

  • c_id (Key) — int — Primary key — NOT NULL
  • s_name (key) — VARCHAR(10) — Foreign key → supply.s_name — NOT NULL
  • info (Field) — VARCHAR(45)
  • c_name (Field4) — VARCHAR(10)

manufacturer (Untitled)

  • m_name (Key) — varchar(10) — Primary key — NOT NULL

product (Untitled2)

  • p_id (Key) — int — Primary key — NOT NULL
  • m_name (Key2) — varchar(10) — Foreign key → manufacturer.m_name — NOT NULL
  • p_name (Field) — VARCHAR(10)
  • count (Field3) — int

supplier (Untitled5)

  • s_name (key) — VARCHAR(10) — Primary key — NOT NULL

supply (Untitled4)

  • s_name (key) — VARCHAR(10) — Foreign key → supplier.s_name — NOT NULL
  • p_id (Field2) — int