prob. 7

Tables (4)

CAR

  • Serial_no (serial_no) — VARCHAR(255) — Primary key
  • Model (model) — VARCHAR(255)
  • Manufacturer (manufacturer) — VARCHAR(255)
  • Price (price) — INT(10)

OPTION

  • Option_name (option_name) — VARCHAR(255) — Primary key
  • Serial_no (serial_no) — VARCHAR(255) — Foreign key → CAR.Serial_no
  • Price (price) — INT(10)

SALES (Untitled2)

  • Serial_no (serial_no) — VARCHAR(255) — Foreign key → CAR.Serial_no
  • Date (date) — INT(6)
  • Sale_price (sale_price) — INT(11)
  • Salesperson_id (salesperson_id) — VARCHAR(255) — Foreign key → SALESPERSON.Salesperson_id

SALESPERSON (Untitled)

  • Salesperson_id (salesperson_id) — VARCHAR(255) — Primary key
  • Phone (phone) — INT(10) — Primary key
  • Name (name) — VARCHAR(255)