7

Tables (5)

Customer

  • Cust# — Primary key — NOT NULL
  • Cname
  • Street
  • City
  • Zip
  • Phone
  • State

Invoice

  • Invoice# — Primary key — NOT NULL
  • TotalOrderAmt
  • Date
  • Terms
  • ShipVia
  • Cust# — Foreign key → Customer.Cust# — NOT NULL

LineItem

  • Invoice# — Foreign key → Invoice.Invoice# — NOT NULL
  • Prod# — Foreign key → Product.Prod# — NOT NULL
  • SellPrice
  • Quantity

Place (Untitled)

    Product

    • Prod# — Primary key — NOT NULL
    • description
    • StandardPrice