homework1-7
Tables (4)
Car (Untitled)
- Serial_no (Field) — 1 — Primary key
- Model (Field2) — Y
- Manufacturer (Field3) — Pord
- Price (Field4) — 8500
OPTION (Untitled2)
- Serial_no (Field) — 1 — Foreign key → Car.Serial_no
- Option_name (Field2) — FULL
- Price (Field3) — 500
SALE (Untitled3)
- Serial_no (Field) — 1 — Foreign key → Car.Serial_no
- Date (Field3) — 230101
- Sale_price (Field4) — 9000
- Salesperson_id (Field5) — 1235 — Foreign key → SALESPERSON.Salesperson_id
SALESPERSON (Untitled4)
- Salesperson_id (Field) — 1235 — Primary key
- Name (Field2) — Lee
- Phone (Field3) — 1234-1234