ERD_Exercise2_답안
테이블 (4)
ACTIVITY (Untitled)
- Key (actCode) — integer — 기본 키 — NOT NULL
- Key (classCode) — 외래 키 → CLASS.Key — NOT NULL
CLASS (Untitled2)
- Key (classCode) — 기본 키 — NOT NULL
- Field (name)
- Field (time)
- Field (maxRe)
- Field (nowRe)
- Field (level)
- Field (descriptiom)
- Key (actCode) — integer — 외래 키 → ACTIVITY.Key — NOT NULL
ENROLL (Untitled4)
- Key (actCode) — 기본 키 — NOT NULL
- Key (memID) — 외래 키 → MEMBER.Key — NOT NULL
- Key (classCode) — 외래 키 → CLASS.Key — NOT NULL
MEMBER (Untitled3)
- Key (memID) — 기본 키 — NOT NULL
- Field (name)
- Field (phone)
- Field (address)
- Field (email)
- Field (age)
- Field (gender)