hw1

Tables (3)

items (Untitled2)

  • PK (item_id) — Primary key — NOT NULL
  • field (item_price)
  • field (item_category)

stocks (Untitled3)

  • PK (stock_id) — Primary key — NOT NULL
  • FK (store_id) — Foreign key → stores.PK — NOT NULL
  • FK (item_id) — Foreign key → items.PK — NOT NULL
  • field (stock)

stores (Untitled)

  • PK (store_id) — Primary key — NOT NULL
  • field (store_address)