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