ERD Excercise2

Tables (3)

CLASS (Untitled2)

  • classNum (Key) — char(10) — Primary key — NOT NULL
  • memberName (Key2) — char(10) — Foreign key → MEMBER.memberName — NOT NULL
  • code (Field) — char(20)
  • hour (Field2) — integer
  • limit (Field3) — integer
  • now (Field4) — integer

MEMBER (Untitled3)

  • memberName (Key) — char(10) — Primary key — NOT NULL
  • address (Field) — char(30)
  • age (Field2) — integer
  • level (Field3) — char(10)

SPORTS (Untitled)

  • sportsType (Key) — char(20) — Primary key — NOT NULL
  • classNum (Key2) — char(10) — Foreign key → CLASS.classNum — NOT NULL
  • memberName (Key22) — char(10) — Foreign key → CLASS.memberName — NOT NULL
  • sportsCode (Field) — char(10)
  • sportsInform (Field2) — char(40)