1

Tables (3)

MyStore (Untitled3)

  • Name (name) — Primary key — NOT NULL
  • Product_name (product_name) — VARCHAR — Foreign key → Product.Product_name — NOT NULL
  • Store_name (Key) — VARCHAR — Foreign key → convience_store.Store_name — NOT NULL

Product (Untitled2)

  • Product_name (product_name) — VACHAR — Primary key — NOT NULL
  • Expiration_date (expiration_date)
  • Price (price)
  • Stock (icecream)

convience_store (Untitled)

  • Store_name (Key) — VARCHAR — Primary key — NOT NULL
  • Location (location)