ERD예제 2
테이블 (4)
Untitled (CLASS)
- Key (classID) — 기본 키 — NOT NULL
- Field (time)
- Field (level)
- Field (limitedNumber)
- Field (numberOf registerred)
- Key (programName) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (name) — char(30) — 기본 키 — NOT NULL
- Field (address) — char(30)
- Field (age)
- Field (telephone)
Untitled (PROGRAM)
- Key (programName) — 기본 키 — NOT NULL
Untitled (ACTIVITY)
- Key (activityID) — 기본 키 — NOT NULL
- Key (name) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (classID) — 외래 키 → Untitled.Key — NOT NULL