ERD 연습문제2

테이블 (4)

Untitled (ACTIVITIES)

  • Key (actCode) — int(6) — 기본 키 — NOT NULL
  • Field (Aerobics) — char(20)
  • Field (Yoga) — char(20)
  • Field (swimming) — char(20)
  • Field (description) — text

Untitled (CLASS)

  • Key (classNo) — int(6) — 기본 키 — NOT NULL
  • Field (operating hours) — char(10)
  • Field (limeted number of person) — int(2)
  • Field (resisterd number of person) — int(2)
  • Key (actCode) — int(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MEMBER)

  • Key (memberID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (age) — int(3)

Untitled (Registration)

  • Key (registID) — int(10) — 기본 키 — NOT NULL
  • Field (Level) — text
  • Key (classNo) — int(6) — 외래 키 → Untitled.Key — NOT NULL
  • Key (memberID) — int(10) — 외래 키 → Untitled.Key — NOT NULL