ex5

Tables (5)

Merchandise (Untitled2)

  • stock (Field) — integer
  • Field2

Shoe (Untitled)

  • sCode (Key) — char(7) — Primary key — NOT NULL
  • sStyle (Field)
  • sColor (Field2)
  • sSize (Field3) — integer

customer (CopyOfUntitled32)

    provier (CopyOfUntitled3)

    • pId (Key2) — Primary key — NOT NULL
    • sCode (Key) — char(7) — Foreign key → Shoe.sCode — NOT NULL

    stock (Untitled3)