AW5-1

Tables (5)

CONTACT

  • ContactID — AutoNumber — Primary key — NOT NULL
  • Date — Date/Time — NOT NULL
  • Type — Text — NOT NULL
  • Remarks — Text
  • CustomerID — AutoNumber — Foreign key → CUSTOMER.CustomerID — NOT NULL

CUSTOMER

  • CustomerID — AutoNumber — Primary key — NOT NULL
  • LastName — Text — NOT NULL
  • FirstName — Text — NOT NULL
  • Address — Text
  • City — Text
  • State — Text
  • ZIPz (ZIP) — Text
  • Phone — Text — NOT NULL
  • Fax — Text
  • E-mail — Text
  • NickName — Text — Foreign key → SALESPERSON.NickName — NOT NULL

SALESPERSON

  • NickName — Text — Primary key — NOT NULL
  • LastName — Text — NOT NULL
  • FirstName — Text — NOT NULL
  • HireDate — Date/Time — NOT NULL
  • WageRate — Double — NOT NULL
  • CommissionRate — Double — NOT NULL
  • Phone — Text — NOT NULL
  • Email — Text — NOT NULL

SALESPERSON_VEHICLE_INT

  • NickName (NickName2) — Text — Foreign key → SALESPERSON.NickName — NOT NULL
  • InventoryID (InventoryID2) — AutoNumber — Foreign key → VEHICLE.InventoryID — NOT NULL

VEHICLE

  • InventoryID — AutoNumber — Primary key — NOT NULL
  • Model — Text — NOT NULL
  • VIN — Text — NOT NULL