a

Tables (4)

Customer (Untitled2)

  • Cust# (key) — Primary key
  • Cname (Field2)
  • Street (Field3)
  • City (Field4)
  • State (Field5)
  • Zip (Field6)
  • Phone (Field7)

Lineltem (Untitled3)

  • SellPrice (Field)
  • Quantity (Field2)

Product (Untitled4)

  • Prod# (Key) — Primary key — NOT NULL
  • StandardPrice (Field)
  • Description (Field2)

invoice (Untitled)

  • Invoice# (key) — Primary key
  • Date (Field)
  • TotalOrderAmt (Field2)
  • Terms (Field4)
  • ShipVia (Field5)