필수2_DB설계_ERD작성실습

테이블 (5)

Coaches (coches)

  • Id (id) — INT(11) — 기본 키 — NOT NULL
  • GroupName (group_name) — VARCHAR(15) — 외래 키 → Group.GroupName — NOT NULL
  • Job (job) — VARCHAR(45)
  • Field

Consultants (consultants)

  • Id (id) — INT(11) — 기본 키 — NOT NULL
  • GroupName (group_name) — VARCHAR(15) — 외래 키 → Group.GroupName — NOT NULL
  • Job (job) — VARCHAR(45)
  • Field

Group (group)

  • GroupName (group_name) — VARCHAR(15) — 기본 키 — NOT NULL
  • Location (location) — VARCHAR(45) — 외래 키 → Locations.Location — NOT NULL
  • GroupNumber (group_number) — INT(11)
  • Field

Locations (locations)

  • Location (location) — VARCHAR(45) — 기본 키 — NOT NULL
  • Field

Students (students)

  • Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
  • GroupName (group_name) — VARCHAR(15) — 외래 키 → Group.GroupName — NOT NULL
  • Year (year) — INT(4)
  • Related Major (related_major) — BOOLEAN
  • Exit (exit) — BOOLEAN
  • Name (name) — VARCHAR(45)
  • Age (age) — INT(4)
  • Gender (gender) — VARCHAR(11)
  • Field