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