Car dealearship

Tables (4)

CAR (Untitled)

  • Serial_NO (serial_no) — integer — Primary key — NOT NULL
  • model — character
  • manufacturer — character
  • price — integer

OPTION (Untitled2)

  • Serial_NO (serial_no) — integer — Foreign key → CAR.Serial_NO — NOT NULL
  • Option_name (option_name) — character
  • price — integer

SALE (Untitled3)

  • Serial_NO (serial_no) — integer — Foreign key → CAR.Serial_NO — NOT NULL
  • salesperson_id — character — Foreign key → SALESPERSON.salesperson_id — NOT NULL
  • Date (date) — integer
  • sale_price — integer

SALESPERSON (Untitled4)

  • salesperson_id — character — Primary key — NOT NULL
  • name — character
  • phone — integer