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)