ERD exercise 2(20200909)

Tables (4)

CLASS (Untitled2)

  • clNo (Key) — CHAR(4) — Primary key — NOT NULL
  • time (Field) — time
  • capacity (Field2) — int(4)
  • currentPersonnel (Field3) — int(4)
  • leCode (Key2) — CHAR(4) — Foreign key → LEPORTS.code — NOT NULL

LEPORTS (Untitled)

  • code (Key) — CHAR(4) — Primary key — NOT NULL
  • explanation (Field) — CHAR(50)

MEMBER (Untitled3)

  • name (Key) — CHAR(10) — Primary key — NOT NULL
  • address (Field) — CHAR(50)
  • age (Field2) — int(4)

REGISTERFOR (Untitled4)

  • clNo (Key) — CHAR(4) — Foreign key → CLASS.clNo — NOT NULL
  • name (Key2) — CHAR(10) — Foreign key → MEMBER.name — NOT NULL
  • level (Field) — CHAR(10)