ERD 연습문제 2번

테이블 (4)

ACTIVITY (activity)

  • Activity ID (activity id) — char(20) — 기본 키 — NOT NULL
  • Activity_Code (activity_code) — char(30)
  • Activity_Name (activity_name) — char(30)
  • Description (description) — text

CLASS (class)

  • Class ID (class id) — char(20) — 기본 키 — NOT NULL
  • Activity ID (activity id) — char(20) — 외래 키 → ACTIVITY.Activity ID — NOT NULL
  • Time_Slot (time_slot) — datetime
  • Max_Capacity (max_capacity) — int(3)
  • Current_Enrollments (current_enrollments) — int(3)
  • Member_ID (member_id) — char(10) — 외래 키 → MEMBER.Member_ID — NOT NULL

MEMBER (member)

  • Member_ID (member_id) — char(10) — 기본 키 — NOT NULL
  • Registration_ID (registration_ID) — char(10) — 외래 키 → REGISTRATION.Registration_ID — NOT NULL
  • Member Name (member name) — char(20)
  • Address (address) — char(30)
  • Age (age) — int(3)

REGISTRATION (registration)

  • Registration_ID (registration_ID) — char(10) — 기본 키 — NOT NULL
  • Difficulty_Level (difficulty_level) — char(10)