과제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)