과제2

테이블 (4)

CAR (Untitled)

  • Serial_no (Key) — 기본 키 — NOT NULL
  • Model (Field)
  • Manufacturer (Field2)
  • Price (Field3)

OPTION (Untitled2)

  • Serial_no (Key2) — 외래 키 → CAR.Serial_no — NOT NULL
  • Option_name (Field)
  • Price (Field2)

SALE (Untitled3)

  • Salesperson_id (Key3) — 외래 키 → SALESPERSON.Salesperson_id — NOT NULL
  • Serial_no (Key2) — 외래 키 → CAR.Serial_no — NOT NULL
  • Date (Field2)
  • Sale_price (Field3)

SALESPERSON (Untitled5)

  • Salesperson_id (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Phone (Field2)